How can we find the open transactions details in sql server?

 Posted by Virendradugar on 11/19/2009 | Category: Sql Server Interview questions | Views: 16015

Yes, it is possible.

select * from sysprocesses where open_tran > 0

This query will provide list of all the open transaction details.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response