question relatated to User log

  • 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

  • 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 ).


Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply