How to find Sql Server properties programatically

[Verve]

I am writing a program in .Net to retrieve properties of Sql Server.
How can I find the following properties without querying the database:

1. Replication enabled
2. Default language
3. Processors and threads running.

Thanks,
verve

[Simon Hayes]

Re: How to find Sql Server properties programatically

You're probably looking for SQLDMO, which is a COM interface to MSSQL -
see Books Online for the details.

1. You can use the SQLDMO Replication object to enumerate replicated
databases, individual publications and articles etc.

2. Use the SQLServer.Langu age property

3. I'm not sure exactly what you want, but WMI might be a better option
for hardware and OS information. If by "threads" you really mean SQL
Server processes, then you can use the SQLServer.EnumP rocesses method

In many cases, SQLDMO executes TSQL commands behind the scenes, so you
still need an authenticated connection to the server (and possibly a
user mapping in individual databases) to use it.

Simon

[Verve]

Re: How to find Sql Server properties programatically

Hi,
Thanks for the prompt reply but can also tell me which classes I should
be querying in WMI or which interface?

Thanks in advance :)
Verve

[Simon Hayes]

Re: How to find Sql Server properties programatically

The full WMI reference is on MSDN, but the TechNet scripting library
might be a faster way to get started:

http://www.microsoft.com/technet/scriptcenter/scripts/hardware/basic/hwbavb03.mspx

http://www.microsoft.com/technet/scriptcenter/scripts/os/process/procthd/pcthvb07.mspx

Simon