how to trace or monitor previous actions in sql server 2012. Like previous using delete command . I want to know who is used that command in server.

how to trace or monitor previous actions in sql server 2012. Like previous using delete command . I want to know who is used that command in sql server . what is the solution?

Hello,

You need to use SQL Server Audit.

http://bradmcgehee.com/2010/03/30/an-introduction-to-sql-server-2008-audit/

http://social.technet.microsoft.com/wiki/contents/articles/17496.sql-server-2012-sql-audit.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com