How to find out who updated/Deleted on SQL Server

  • Hi,

    How to find out who deleted or updated the values in table in SQL Server. This scenario may occur when there are more than one user who had the access for the same DB.

  • Do you have custom auditing in place?

    Do users login with a generic username or do they have their own username?

  • anthony.green (12/10/2012)


    Do you have custom auditing in place?

    Do users login with a generic username or do they have their own username?

    Do you have custom auditing in place?. I am not able to get it. But if you mean to say that do we manually audit the database using some queries orr by following the process then the answer is no.

    Do users login with a generic username or do they have their own username? Yes each user has its unique name and password.

  • As you dont have custom auditing in place, finding historic updates/deletes will not be possible.

    Look at building custom auditing procedures on the tables you require to know who updated / delete the row, but this will only log future requests, not historic requests.

  • anthony.green (12/10/2012)


    As you dont have custom auditing in place, finding historic updates/deletes will not be possible.

    Look at building custom auditing procedures on the tables you require to know who updated / delete the row, but this will only log future requests, not historic requests.

    Is it possible to find out whether who run alter statement , if auditing process is not there

  • You could check the default trace, but that only keeps so much information before it is lost, so highly unlikely that it will be in the trace.

    Again custom auditing would be the one for that.

  • anthony.green (12/10/2012)


    You could check the default trace, but that only keeps so much information before it is lost, so highly unlikely that it will be in the trace.

    Again custom auditing would be the one for that.

    Now what is this default trace??

Viewing 8 posts - 1 through 7 (of 7 total)

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