MSSQLServer service Down Error number

Hi
I am creating Alerts for MSSQLServer service shutdown. Could you please let me know the error of this.
Urgent please.
Thanks
Raj.Is it just me? ?|||Hi

Ok let me put the question this way. If the MSSQLServer service is shutdown.
I would like to get a alert mail. How can I configure this.

Please help very urgent.

Raj.|||Errr... How can the server send an e-mail when it's shut down?|||I think that I'd just type my email into SQL Agent as an Operator, and check the box to notify me when SQL Server went down unexpectedly.

-PatP|||Pat, I don't see that check box on SQL Server 2000, but am not sure where I would look if not in the operator record and/or in Alerts.

Krajforum:
I suppose you could map a SQL Server event into an alert and have it send an email, eh? Not sure which event you'd have to map though.

I did find a veritible cornucopia of information by searching BOL using the word "alerts", however, including a few how-to's. Perhaps you could start there?|||Is it just me? ?

No

This message is too short

I want an alert when the dba drops the box from a 12 story window

...so I can tell the people below to look out