I didn't think you had to explicitly drop temp tables created with the # prefix?

I thought SQL Server cleaned these up for you.

Try using SCOPE_IDENTITY() as opposed to @@IDENTITY.

@@IDENTITY returns the most recently assigned identity value across the entire database (you're triggered INSERT, for example), whereas SCOPE_IDENTITY() will return the...