tracking who does inserts, deletes etc

• vee van gelder

  Ten Centuries

  Points: 1337

  More actions

  July 4, 2011 at 5:43 am

  #252952

  is there anything you can enable on sql server to see which users have inserted and deleted into a database or do you need to do that kind of logging manually?

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  July 4, 2011 at 8:41 am

  #1347897

  Some options:

  > SQL Trace can provide those details on a macro level.

  > Use SQL Audit to capture "Database-Level Audit Actions" (Enterprise Edition only)

  > manually capture DDL events in a logging table using triggers and built-in functions

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato