@@identity is per session, but can return other things if you are using triggers (since the trigger will happen before your retrieval of @@identity). One more

@@identity is per session, but can return other things if you are using triggers (since the trigger will happen before your retrieval of @@identity). One more reason I hate triggers (we also use scope_identity only). More fun @ http://msdn.microsoft.com/en-us/library/ms187342.aspx http://msdn.microsoft.com/en-us/library/ms187342.aspx