>If I remember correctly, @@IDENTITY doesn't apply to GUIDs, right? I am using uniqueidentifiers....
>
No, it doesn't apply. You can create new GUID with NewID()
Also it's much better and safer to use SCOPE_IDENTITY() to get the newly created ID.
>>We have an identity column on every table and use @@IDENTITY to check inserts:
>>
>>
http://www.kamath.com/tutorials/tut007_identity.asp>>
If it's not broken, fix it until it is.
My Blog