ALert When Database State Changes

• Vasu-709835

  SSC Eights!

  Points: 921

  More actions

  June 21, 2010 at 6:18 am

  #145365

  Hi Friends,

  How to Create a alert for Database STate changes?

  (EG : if State changes from ONLINE to OFFLINE then i should get alert,

  I can query sys.databases to find the Database STate BUt I need to get alert when State changes)

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  June 21, 2010 at 6:29 am

  #1182685

  Have you looked at DDL triggers?

  John