Post reply

need to track user

  • November 8, 2012 at 11:40 am

    #266835

    Hello

    in one table, i need to find from which sql account, table got insert , update and delete.

    so please help me, how i track this

    Thanks

  • November 8, 2012 at 12:13 pm

    #1557326

    yogi123 (11/8/2012)

    Hello

    in one table, i need to find from which sql account, table got insert , update and delete.

    so please help me, how i track this

    Thanks

    Unless you've already setup a DML trace or audit, the data you are looking for is not saved anywhere.

    you cannot find out whodunnit information after the fact.

    you could add a DML trace, CDC, DML event notification or use SQL Audit in the future to capture that info, but that probably doesn't help with the finger pointing you are looking for today.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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