1
kudos
spam Kudos Remove

TSQL to get list of operations in active transaction of the current session
published 837 days, 5 hours, 44 minutes ago posted by sasa 846 days, 17 hours, 30 minutes ago
Sunday, February 07, 2010 12:21:05 AM GMT Thursday, January 28, 2010 12:35:06 PM GMT
TSQL to get list of operations in active transaction of the current session
SQL Server has a wealth of Dynamic Management Views (DMVs) to get you health status of the platform. All the data will be extracted with a query, set of transactions and many more ways, in this case you had to be careful with transactions, because whenever so much data was flowing back and forth between the application server and the database server, too many things could go wrong. Here is the quick DMV that can get you list of operations in active transaction of the current session declare @xactid...(read more)
category: News | clicked: 1 | | source: sqlserver-qa.net | show counter code
tags: active, DMV, new features, SQL Server, transaction, TSQL

No comments yet, be the first one to post comment.

To post your comment please login or signup