CODEWITHSUNDEEP
sql-server
semer sead
semer sead

Reputation: 1

I want to see what queries have been run in an uncommitted transaction

Is it possible to see what queries have been run in an uncommitted transaction?

I tried Sp_who2 but I want to see the full query of the uncommitted trans.

Upvotes: 0

Views: 36

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 88851

Is it possible to see what queries have been run in an uncommitted transaction?

No. You can see the locks that are still held by the session, which will give you some indication. But without a Trace/XEvent you can't see all the queries.

Upvotes: 1

Related Questions