August 12, 2009 at 1:54 am
Can any one please help me how we can configure alerts when there is changes in database on a certain table ?
August 12, 2009 at 3:27 am
can't understand your question. Give some more info..
-LK
August 12, 2009 at 3:28 am
have a look in BOL about DDL triggers (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/edeced03-decd-44c3-8c74-2c02f801d3e7.htm)
You will need to do a database scoped DDL trigger and in it use an if statement to check the object name/id of the object being modified. from there you can either build an alert in using the raiseerror statement, or you could send an email using msdb.dbo.sp_send_dbmail, there are a few options and its up to you which you want to use.
August 12, 2009 at 3:30 am
luckysql.kinda (8/12/2009)
can't understand your question. Give some more info..-LK
on reading the question your right. i assumed on first reading it was schema related changes, however this isnt specified by the OP.
OP - Do you want to know when someone changes data or schema?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply