find out who deleted a row

Is there a way in sql 2005 to find out who has deleted a row from a table? thanks
LVL 8
CamilliaAsked:
Who is Participating?
 
knightEknightConnect With a Mentor Commented:
add an "after delete" trigger to the table that inserts deleted rows into an archive table ... include two additional columns in the archive table to hold the values of these two functions respectively:  original_login() and user_name()
0
 
CamilliaAuthor Commented:
no other way....so sql server itself doesnt have some kind of logging/tracking to see who's deleted?
0
 
LowfatspreadConnect With a Mentor Commented:
not unless you have full logging enabled and a log analysis tool like "redgate" available...

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.