trace out the time and user who made changes to tables

Tags:
SQL Server
hai everybody.. some one has intruded mine database and droped two columns of my table.. is there any way to get the information regarding the user,date and time of modified table.. thanks in advance
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

I am assuming you are using MS SQL Server. There are two things that may be of assistance to you.

1) If you have security auditing turned on, you can view the logs to see when users logged in successfully or failed to login. Viewing this may give you clues as to when this happened or what account may have been used.

2) For future monitoring, if you believe there is a risk of this happening again, you can run a trace in SQL Profiler. You can capture all sorts of information using Profiler, including user name, host name, query text, reads, writes, cpu usage, etc.

I wish there were a more complete solution for tracing these sorts of things out of the box, but these are decent tools.

-Stephen

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: