Database Mail

• Ram:)

  SSCrazy

  Points: 2246

  More actions

  July 21, 2010 at 3:22 pm

  #148098

  Hi,

  It is just my interest to implement in our production... Please help me if any possibillities..

  My interest is to get mail when ever updations done in Securities.. like create login.. or giving permissions to existing login.. adding remote servers.. etc.

  Ram...

  

• Sankar Reddy

  SSCrazy

  Points: 2410

  More actions

  July 21, 2010 at 5:31 pm

  #1196569

  [font="Courier New"]

  Your best bet is to use Event Notifications and look for the specific events you are interested in.

  Jonathan Kehayias has done a very good write up on Event Notifications (Getting Started with SQL Server Event Notifications[/url]) and this article (http://msdn.microsoft.com/en-us/library/ms190297(v=SQL.90).aspx) from BOL lists the events that can be tracked.

  [/font]

  [font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]