October 13, 2011 at 11:59 pm
Hi
Is it possible to send out an email when certain events take place from inside SQL? e.g: when a database is attached or restored an email goes out saying who the logged in user is and what database it was that was attached.
Thanks in advance 😀
The Fastest Methods aren't always the Quickest Methods
October 14, 2011 at 2:15 am
Yes that is possible. Depending on the events you want to monitor look for DDL triggers http://msdn.microsoft.com/en-us/library/ms186406(v=SQL.90).aspx
or Event Notifications http://msdn.microsoft.com/en-us/library/ms175854(v=SQL.90).aspx
[font="Verdana"]Markus Bohse[/font]
October 14, 2011 at 5:25 am
Thanks, will look into it 🙂
The Fastest Methods aren't always the Quickest Methods
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply