Skip to content

Instantly share code, notes, and snippets.

@amtwo

amtwo/Check_OpenTransaction_SessionInfo.xml Secret

Created December 31, 2017 18:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amtwo/3d3e66a09e64deba440c76f794202cad to your computer and use it in GitHub Desktop.
Save amtwo/3d3e66a09e64deba440c76f794202cad to your computer and use it in GitHub Desktop.
Download ZIP
Sample output from Check_OpenTransaction
Raw
Check_OpenTransaction_SessionInfo.xml
<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