>>>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 >
I'll have to do a search of the MS KB on this, Chris. Hopefully, since we're in 7.0 this will be something that's been fixed.
The only problem (so far) that I've had is that the VFP upsizing wizard (even in SP 4) wants the compatibility level set no higher than 6.5. So it's been into the Query Analyzer, set the compatibility level, upsize the table, then set it back.
George
Ubi caritas et amor, deus ibi est