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" <be*****@cherwellinc.com> wrote in message
news:u1**************@TK2MSFTNGP09.phx.gbl...

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

[Bernie Yaeger]

Hi,

Tx for the advice.

Bernie
"The Grim Reaper" <gr*********@btopenworld.com> wrote in message
news:ca**********@titan.btinternet.com...

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" <be*****@cherwellinc.com> wrote in message
news:u1**************@TK2MSFTNGP09.phx.gbl...

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