Posted by David Portas on 09/27/05 12:04
Assuming you are using SQL Server 2000 then use SCOPE_IDENTITY() rather than @@IDENTITY. SCOPE_IDENTITY won't be affected by an insert in the trigger. -- David Portas SQL Server MVP --
[Reply to this message]
Copyright © 2005-2006 Powered by Custom PHP Programming