Home Forums SQL Server 2008 SQL Server Newbies how to find owner(SPID) of the temp tables RE: how to find owner(SPID) of the temp tables
Erin Ramsay
SSCrazy Eights
Points: 9728
More actions
April 9, 2013 at 3:24 pm
#1605044
I suppose you COULD write a server level trigger to append the SPID to the table extended properties. Not sure how useful that would be.