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
SQL Show
SSCertifiable
Points: 6143
More actions
April 4, 2013 at 5:12 am
#1603488
Not sure we can achive this. Better name your temptable with SPIDs.
sys.dm_db_session_space_usage will give you some details about temp tables' usage.