If a SQL Server database locks up or data integrity is lost, it should notify the database administrator automatically. While SQL Server has this feature, there are some hurdles to overcome.
The major obstacle to the standard notification features of SQL Server revolve around the requirements for a MAPI subsystem to be present on the server. One way to clear this hurdle is with CDOSYS.
[b]Is your SQL Server system set up with automated notification? Did you have difficulty setting it up?[/b]
