InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:25:49 GMT20http://www.sqlservercentral.com/Forums/Topic546219-146-1.aspxThanksI have been looking thru the BOL under Notifications. Still readingI will look at what you suggested.ThanksAndrew SQLDBAMon, 04 Aug 2008 12:21:15 GMTAndrewSQLDBAhttp://www.sqlservercentral.com/Forums/Topic546219-146-1.aspxTake a look at "Create Event Notification" and the linked articles from it, in Books Online. Should have the data you need in there.Mon, 04 Aug 2008 11:54:02 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic546219-146-1.aspxI know Error 40002 is a comm error but may be an app connection error, BOL should have a list. You can always define a custom error number, but it has to be > 50000.Mon, 04 Aug 2008 11:03:46 GMTheftyphttp://www.sqlservercentral.com/Forums/Topic546219-146-1.aspxI know there should be something, but what? Do you happen to know of the Number?ThanksAndrew SQLDBAMon, 04 Aug 2008 10:49:08 GMTAndrewSQLDBAhttp://www.sqlservercentral.com/Forums/Topic546219-146-1.aspxYou can base a notification on an error message number or severity level. I'm pretty sure a communication error like that should set something off.Mon, 04 Aug 2008 10:17:58 GMTheftyphttp://www.sqlservercentral.com/Forums/Topic546219-146-1.aspxHello EveryoneI am trying to setup notifications for all my 2005 database servers. The database(s) themselves reside on a SAN, while the database server is it own box. I would like to create a notification that will email me when the database server cannot communicate with the database.So if the SAN were to be taken offline, I would like to receive an email stating that the database cannot be opened, or contacted, you get the point.ThanksAndrew SQLDBAMon, 04 Aug 2008 10:16:08 GMTAndrewSQLDBA