sql server (alternate): Can you give me the step-by-step procedure to setup some alerts in SQL
2000 to get pager or email notification once the :

1- SQL Server (service) is down

[quoted text, click to view]

1. SQL Server Agent can send an alert if the MSSQL process reports a
fatal error, but if it's down as well, it won't be able to alert you.
So you may want to look at it as a general Windows issue - if you
already have a Windows event monitoring system in place, then you can
use that to do something when the MSSQL services stop and start (by
default, they are set to auto restart). You can also use the Control
Panel Services applet to do something (run a script etc.) when a
service fails to start.

2. Email/pager notifications require SQL Mail:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556

After doing that, then you can use Enterprise Manager to create
whatever alerts you need. There is a demo alert already created for a
full log condition, so you can use it as a template.

[quoted text, click to view]

For #1, look at the Windows Service manager.

This has a "Recovery" tab, and the ability to run a custom program on
service failure.

....

Steven