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

MSSQL Question

Is there a way to find out the last time a row was updated without creating a field to contain the timestamp?
Any help is greatly appreciated!
Thanks,
JeffAnyway you have to have field where it is possible to save last time of update. It could be datetime, varchar, etc. You can use trigger for saving data in this field or use sp during update.|||If this is a requirement you might look into a third party tool called Lumigent Log Explorer or Lumigent Entegra. www.lumigent.com