Enum the running SQL instances using DMO

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • velu5

    Enum the running SQL instances using DMO

    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

    ListAvailableSQ LServers Method
    ListInstalledIn stances 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
Working...