Here is the below query to identify.
# Sql server orphaned transactions
select * FROM master..syslockinfo WHERE req_spid=-2
Regards,
Chaitanya
- Comment
- Reblog
-
Subscribe
Subscribed
Have a WordPress.com account? Log in now.
