SQL Server Profiler Query

• frontpedal

  SSC Journeyman

  Points: 86

  More actions

  June 8, 2009 at 7:03 am

  #205663

  Hi, Im new to SQL Server profiler, (on 2000 here unfortunatley), and have a query :

  I have setup a trace within SQL Server profiler, looking to see when Data is committed to the database. I can see the profiler capture data which obviously is the SQL input, TextData fileld = INSERT INTO Alerts (Username, AlertDate, DOB, LastSeenDateTime, LastSeenPlace, LastSeenBy, HatCap, [Top], TrousersSkirt, Footwear, [ID], LastSeen.

  The trace also has the following columns.

  EventClass, ObjectID, ObjectName, ObjectType, TransactionID, TargetUserName, TargetLoginName, TargetLoginSID, Severity, ServerName, DatabaseID, DBUserName, Error, EventSubClass,

  How can I tell that the INSERT INTO was committed to the database i.e not rolled back and see what actual data the INSERT INTO command wrote to the Database.

  Also, How would I tell if transaction had been rolled back and what data it was rolling back ?

  Any help would be very much appreciated.

• shahm10

  SSCrazy

  Points: 2217

  More actions

  July 14, 2009 at 3:04 pm

  #1024730

  Start a SQL Trace and add SQL:Stmt Started and SQL:Stmt Completed

  or Batch Started and Batch Completed parameters.