Browse by Tags

• object_name
• tables
• tsql

Retrieve SessionID and batch information
24 July 07 02:37 AM | SQL Master | 1 Comments   

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 Read More...

Filed under: tsql, performance, tables, object_name, forced, cache