SQL Sever Transactions [Resolved]

Posted by Murugavelmsc under Interview Questions on 4/2/2013 | Points: 10 | Views : 1747 | Status : [Member] | Replies : 2
The _____ object is used to retrieve information about all active transactions on an instance.

A) Sys.dm_tran_active_transaction
B) Sys.dm_active_trasactions
C) Sys.dm_tran_transactions
D) None of the above

Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/



Responses

Posted by: Satyapriyanayak on: 4/2/2013 [Member] [MVP] Silver | Points: 50

Up
0
Down

Resolved
sys.dm_tran_session_transactions

If this post helps you mark it as answer
Thanks

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 4/2/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi
s

refer this

http://blog.sqlauthority.com/2008/07/24/sql-server-2005-track-down-active-transactions-using-t-sql/

Mark as Answer if its helpful to you

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response