beejug1983 (8/6/2010)
Hi,Is there any way to find out details of particular transaction. We can check current transaction ID in SQL 2005, but can we check the whole details of transaction ? Like who is the owner of transaction, database, complete T-SQL of that transaction without using tracing or auditing ?
Thanks in advance:)
you can use sys.sysprocesses to get a lot of that information.
you can use dbcc inputbuffer to get the t-sql statement. There are also various DMV's you can use to get similar information