July 27, 2008 at 1:57 pm
Hi, we have a problem with a program that use SQL Server 2005, it show us an error, and I will like to know if it is a log that have the last transacctions that was execute on a databases, and to do it.
Thanks
July 27, 2008 at 4:57 pm
Did you try DBCC OPENTRAN
Or you can run sp_who2 to find a runnable spid, then run
DBCC INPUTBUFFER(spid)
May the above help.
July 28, 2008 at 7:13 am
Or, since it's not always possible to capture a transaction while it's open, use Profiler to set up a trace and capture the output from your procedures to a file. You can then go back and peruse them at your leisure (as well as aggregate the data for reporting & trending & analysis, etc.).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply