SQL Server Profiler

  • 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 filed = 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 data physical 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.

  • Duplicate posting,

    Don’t answer here

    Answer to: http://www.sqlservercentral.com/Forums/Topic730655-169-1.aspx

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

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