Home > IT Answers > SQL Server > Being notified when a delete operation is performed on SQL Server
SQL Server Ask the Experts
2,585 pts.
 Being notified when a delete operation is performed on SQL Server
SQL Server security
How can I be notified of delete operations in SQL Server? Is there a tool out there (or something) that will notify me when a user performs a delete operation, without the user knowing about this activity?

Software/Hardware used:
ASKED: July 23, 2009  5:31 PM
UPDATED: July 24, 2009  2:25 PM
RELATED QUESTIONS
Answer Wiki:
If you want to track deletions on specific tables, one option could be the use of <a href="http://msdn.microsoft.com/en-us/library/ms189799.aspx">triggers</a> and the <a href="http://msdn.microsoft.com/en-us/library/ms189505.aspx">xp_sendmail</a> stored procedure. ---------------------
Last Wiki Answer Submitted:  July 23, 2009  7:30 pm  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I have just read that the xp_sendmail extended procedure is being deprecated, and that Database Mail should be used instead.

carlosdl
 63,580 pts.
 

Check DbProtect to see if it does what you’re looking for.

Kevin Beaver
 11,040 pts.