Auto-Broadcast with unscheduled shutdown

Hi there (apologies if this is not the correct question
for this topic)...
1. If the MS SQL Server7 is being shutdown (or crashes)
whether by another DBA or unexpectly due to a power loss -
what do I check for to setup an alert to e-mail/net-
message users?
2. And has anyone any advice on how to setup emails/txt-
message to mobiles and pagers (whereby paging staff might
pick-up the message or an auto-telephone answering
machine).
Cheers.
Wayne1. At the OS level, you can periodically check the SQL
Server service. You can write your own or there are third
party products that provide this type of functionality.
2. You need something to interface with your pagers.
Generally a third party product of some sort. Some provide
functionality to dump a file or send an email for an alert
and then the product translates this file or email and sends
the message to the pager.
-Sue
On Thu, 26 Feb 2004 08:38:00 -0800, "Wayne"
<anonymous@.discussions.microsoft.com> wrote:

>Hi there (apologies if this is not the correct question
>for this topic)...
>1. If the MS SQL Server7 is being shutdown (or crashes)
>whether by another DBA or unexpectly due to a power loss -
>what do I check for to setup an alert to e-mail/net-
>message users?
>2. And has anyone any advice on how to setup emails/txt-
>message to mobiles and pagers (whereby paging staff might
>pick-up the message or an auto-telephone answering
>machine).
>Cheers.
>Wayne|||Thks for the info, Sue!

>--Original Message--
>1. At the OS level, you can periodically check the SQL
>Server service. You can write your own or there are third
>party products that provide this type of functionality.
>2. You need something to interface with your pagers.
>Generally a third party product of some sort. Some provide
>functionality to dump a file or send an email for an alert
>and then the product translates this file or email and
sends
>the message to the pager.
>-Sue
>On Thu, 26 Feb 2004 08:38:00 -0800, "Wayne"
><anonymous@.discussions.microsoft.com> wrote:
>
loss -
might
>.
>

Auto Shutdown Service Manager

Plz Help me.
Auto shutting down of my sql service manager. what i will start it,
but the server is shutdown after 30 seconds. that is why i can't used any
services. Please to help me, what about to start of my sql service manager
and matained of sql server 2000 (enterprice)? Please answer and good thing.
Plz faster and faster moment.
Thank of all and member.
Saw Oo(Myanmar)
Hi,
For Stopping and starting the SQL Server Service please the Control Panel --
Services option.
Thanks
Hari
SQL Server MVP
"SawOo.ygn" <SawOo.ygn@.discussions.microsoft.com> wrote in message
news:AD9546B7-87BB-4386-BB61-F064D200410A@.microsoft.com...
> Plz Help me.
> Auto shutting down of my sql service manager. what i will start it,
> but the server is shutdown after 30 seconds. that is why i can't used any
> services. Please to help me, what about to start of my sql service manager
> and matained of sql server 2000 (enterprice)? Please answer and good
> thing.
> Plz faster and faster moment.
> Thank of all and member.
> Saw Oo(Myanmar)
>