chgn01 (7/27/2016)
Thank you George Vobr, you are right, but if you do not use tempdb, it will not give you the information. The @@trancount will do.
Thanks for Your post. I originally tried the script on a normal table with USE TestDB.
The results are the same as when using the tempdb. DBCC OPENTRAN information
about active transactions always be displayed. Maybe it depends on the used code
or the version of SQL Server.
I remain with best regards G.V.