Thanks, setting the "Enforce constraint for replication" option seems to have done the trick!

Thank you all for the responses.

I've gone with Sean May's suggestion of populating the spid column straight after populating the other columns with DBCC INPUTBUFFER.  This is a vast improvement...

I did think about that but I figured I'd have to process and update one row at a time in my Who2Info table (populate #temp with results from DBCC INPUTBUFFER...

I've got a table which captures the recordset from sp_who2 (all the columns it returns) but using:

INSERT INTO Who2Info EXEC SP_WHO2

The table mirrors the columns in the recordset returned by...