Posted by Simon Hayes on 09/08/05 13:13

You could get most of that information from SQLDMO (see the
Configuration, Registry, Replication and Login objects in the SQLDMO
hierarchy), but some of it isn't really clear - what do you mean by
"backup service", for example? Personally, I would seriously consider
buying a tool to do this, rather than reinvent something myself.

As for connecting to different servers, there's no way to get
information from any server without authenticating first, at the OS
level and/or the MSSQL level. I don't know anything about your
environment, but monitoring is a general systems issue, not an
MSSQL-specific one, so you might need to discuss it with your
manager/colleagues/client, to agree a general solution which allows
scripts and tools to connect to any server. You might create specific
domain accounts for monitoring purposes, for example.

Simon

[Back to original message]