Browse by Tags

All Tags » tsql » object_name » forced (RSS)
Retrieve SessionID and batch information
Published 24 July 7 4:37 AM | SSQA.net
You may be aware using SP_WHO or SP_WHO2 statements you can get information about a session id and statement that is running since good olden days of SQL Server. Within SQL 2005 version you can take help of TSQL: SELECT session_id, text FROM sys.dm_exec_requests...
Filed under: , , , , ,