Finding Sql server orphaned transactions

By Chaitanya Talasila on

Here is the below query to identify.

# Sql server orphaned transactions

select * FROM master..syslockinfo WHERE req_spid=-2

Regards,

Chaitanya

Posted in: sql server

Leave a comment

Design a site like this with WordPress.com
Get started