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

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

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