June 8, 2009 at 7:03 am
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.
July 14, 2009 at 3:04 pm
Start a SQL Trace and add SQL:Stmt Started and SQL:Stmt Completed
or Batch Started and Batch Completed parameters.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply