I'm selecting from TableA into TableB (nothing fancy, just using "insert into") and TableB has an IDENTITY column. It is important that the rows are inserted contiguously. If two processes are both calling the stored proc at the same time and both inserting, say , 1000 rows will sql lock the...more >>