Loading

Monday, July 27, 2009

MSSQL: View actively running commands by SPID

--- View actively running commands by SPID.

select session_id, Text
from sys.dm_exec_requests r
cross apply sys.dm_exec_sql_text(sql_handle) t

Troubleshooting
Backup failed: System.Data.SqlClient.SqlError: Backup and file manipulation... must be serialized

No comments:

Post a Comment