What is the scope of SET IDENTITY_INSERT xyz ON
?
If I use this in one stored procedure for a certain table, what happens if a different user running a different procedure, inserts into that certain table at the same time?
Also, what happens if different users/procedures try to set SET IDENTITY_INSERT xyz ON
for different tables at the same time?