question relatated to User log

• kailash sahu

  SSC Veteran

  Points: 249

  More actions

  January 13, 2004 at 12:24 pm

  #177832

  When any of the user does insert , update or delete to any of the table , or fires any query against the DB , I need some kind of notification or log where I can find the activities going on the SQL server DB , How can i do that , Need help !! Thanks In advance

• sqlpro

  Hall of Fame

  Points: 3859

  More actions

  January 14, 2004 at 1:19 pm

  #490052

  u can use profiler to trace every event.otherwise

  u need to write a trigger on the table you want to know changes which sends you an email(you can use xp_sendmail ).

  cheers