Hello,

I want to enumerate all the RUNNING SQL instances[in a mixed env where
SQL 2000 and SQL2005 are deployed] using SQL DMO.
But any of the following methods would not help

ListAvailableSQLServers Method
ListInstalledInstances Method

because they list all the installed instances and while my intent is
getting only the running instances.

Is there any other direct API ? Pls advise.

Regards,
Velu

You can try the SqlDataSourceEnumerator class in ADO.NET:
http://msdn2.microsoft.com/en-us/library/a6t1z9x2.aspx

Here is an article that describes a couple methods to enumerate instances,
including the newer approach using SMO:
http://www.sqldbatips.com/showarticle.asp?ID=45

In my experience SMO does work much better than DMO.

HTH,

Plamen Ratchev
http://www.SQLStudio.com