Post reply

See the last transacctions that was execute on a databases

  • July 27, 2008 at 1:57 pm

    #381952

    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

    #848925

    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

    #849157

    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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply