Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Sample output from Check_OpenTransaction
<Transaction>
<TransactionState>The transaction has generated log records.</TransactionState>
<TransactionLengthMinutes>199</TransactionLengthMinutes>
<SessionID>56</SessionID>
<DbName>AdventureWorks2014</DbName>
<LoginName>AMallon</LoginName>
<HostName>AMALLON-LT</HostName>
<DbName>AdventureWorks2014</DbName>
<LoginTime>2017-12-29 11:17:30</LoginTime>
<LastRequest>2017-12-31 10:02:20</LastRequest>
<ProgramName>Microsoft SQL Server Management Studio - Query</ProgramName>
</Transaction>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment