Check out the solution in the video TSQL: DBCC OPENTRAN. In honor of one of my favorite DBAs, we look at using the DBCC OPENTRAN. We simulate an example with this technique and show what we see and what we would use it for in some situations.
Check out the highest-rated Automating ETL course on Udemy, if you're interested in data.
There's a variety of ways to get an open transaction if we need. How should we get the open transaction? It depends on what we need to do with it.