Monitor Object Changes

Total article views: 1181 | Views in the last 30 days: 7

 Rate this |   Join the discussion |  Briefcase

Based on post http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=4349 I decided to write this script which will check for object changes in all databases and send an email listing the objects changed to the Operator associated with the job. This by no means offsets the need to restrict change access to objects in production, but in those cases when you can't restrict it is a nice basic monitor.

The first part of the script will create the job (you need to change the @owner_login_name and @notify_email_operator_name information) and the second part creates the procedure to check for changes.

Pretty simple but effective.

Total article views: 1181 | Views in the last 30 days: 7