September 3, 2008 at 12:23 am
I am in production environment.some user has deleted the rows from a table how can i know who performed that operation.
Any help is appreciated.
September 3, 2008 at 12:31 am
unless you have profiler running a trace or you have a trigger which stores audit data like "who did what" in a table, it may not be possible.
"Keep Trying"
September 3, 2008 at 1:48 am
its a production table i cant add any trigger or column to a table without approvals.Is there any other way to find it.
September 3, 2008 at 2:24 am
IF you are really running on SQL 7, 2000 then you are out of luck if you application/database does no auditing and you don't have a trace already running.
If you are on SQL Server 2005 you may be able to find out using the default trace started on installation based on the time it was done.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply