>>
>>OTOH, we also use the 'practice' of using meaningless int fields as PKs and they indeed avoid a lot of problems. OTOH, it does not make any other 'practise' against the relational model or even bad practice.
>>
>>Walter,
>
>True, but as soon as you write a trigger and try to join
>INSERTED and DELETED tables as you do it?
I hate to jump in with a simple "good point", but that's a very good point. It's going to have at least some impact on the traditional patterns and processes for audit trail logging.