monitoring sql server through vb .net

[Bernie Yaeger]

I've developed and am deploying a very important enterprise wide app for a
client. This app controls virtually everything the client does, and has
been thoroughly tested. However, I am a bit concerned about sql server
2000.

I noticed just the other day - still testing - that the server, when opened
in EM, said 'suspect'. I had been doing some fooling around and I know what
caused it. But my concern is, how can I monitor the server for this or
other failures to be able to react quickly - with a backup when necessary -
whenever something serious occurs? Is there a way, either inside vb .net or
by other means of continually polling the server for its health?

(I've cross posted on sqlserver ng also.)

Thanks for any recommendations.

Regards,

Bernie Yaeger

 

[The Grim Reaper]

Look up SQL DMO in MSDN - it's a com dll for monitoring/controlling SQL
server services, configuration and security settings.
_______________________________
The Grim Reaper

 

[Bernie Yaeger]

Hi,

Tx for the advice.

Bernie

Look up SQL DMO in MSDN - it's a com dll for monitoring/controlling SQL
server services, configuration and security settings.
_______________________________
The Grim Reaper

..net