> Once this stored procedure is completed, its “scope” is gone, and SCOPE_IDENTITY() returns NULL rather than > the Autoincrement

Okay, that's of course bad. I thought @@DENTITY just is a global variable and not scoped to a connection, I stand corrected.

Bye, Olaf.