Skip to main content

Posts

Showing posts from November, 2012

DB Change Tracking Alert on My Cell

Hello Friends, 
Recently I have been shared My Post on Change Tracking Log (winlinuxhelp.com) described how I am storing day to day Database schema change logs Of all server for Reporting &  System Analysis purpose. I want to continue writing about this Topic .. 
So today I will share about Change Alert which I have been configured into system to alert on every schema changes into my cell.
To Create run below Script

CreateTRIGGER safety1 ONDATABASE FOR
CREATE_TABLE,ALTER_TABLE,DROP_TABLE, CREATE_PROCEDURE,ALTER_PROCEDURE,DROP_PROCEDURE, CREATE_VIEW,ALTER_VIEW,DROP_VIEW
AS declare @object int declare @hr int declare @rcnum varchar(200) declare @str varchar(200)