>>I am looking more and more at ROWGUIDs for my surrogate PKs, but I am not sure about the performance implications, compared to integer PKs.
>
>That's a good alternative, Chris. I'm using indentity columns because SQL Server (at least 7.0) does the work of creating the surrogate key for me. Then again, I'm lazy.< bg >

I read about some problems concerning IDENTITY columns, so far as a bug (at least in SQL Server 6.5), and an incorrect @@IDENTITY value if you have an INSERT trigger that adds a record to a different table (thereby giving you the @@IDENTITY value of incorret table). But boy did I have trouble figuring out how to create my own keys! Someone here on the UT helped out (I was also too lazy to figure it out myself). < g >