Categories
Linux SQL Windows

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

Leave a Reply

Your email address will not be published. Required fields are marked *