http://www.netvouz.com/aleph/tag/identity?feed=rss aleph's bookmarks tagged "identity" on Netvouz http://msdn2.microsoft.com/en-us/library/ms190315.aspx Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore, two statements are in the same scope if they are in the same stored procedure, function, or batch. tech > programming aleph Tue, 06 Feb 2007 03:11:10 GMT