If your database is clustered, Microsoft Cluster Server does a "select
@@servername" every 5 seconds to check to make sure the SQL Server is
running. You could probably mimic that with a scheduled task in NT to get
the same type of effect - even if your server is not clustered. The user
account you use would just need public access (grant then as a login to
SQL Server but not as a user to any databases).

Thanks,
Lisa Greetham
Database Administrator, Corporate Internet Group
Bank One




"Shibu MB" <[Email Address Removed] 01:41 AM

To
"LazyDBA.com Discussion" <[Email Address Removed] down Alert






Hi all ...

Can anyone suggest me or share the script which checks if the db
(
sqlserver 2000) is up or not and if it goes down or throws an error alert
the DBA???

Thanks
Shibu


DISCLAIMER:
This message (including attachment if any) is confidential and may be
privileged. Before opening attachments please check them for viruses and
defects. MindTree Consulting Private Limited (MindTree) will not be
responsible for any viruses or defects or any forwarded attachments
emanating either from within MindTree or outside. If you have received
this message by mistake please notify the sender by return e-mail and
delete this message from your system. Any unauthorized use or
dissemination of this message in whole or in part is strictly prohibited.
Please note that e-mails are susceptible to change and MindTree shall not
be liable for any improper, untimely or incomplete transmission.




This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

MS Sql Server LazyDBA home page