List of SQL Servers

[Sean McKaharay]

I am trying to find a way to return a list of my sql servers other then
using SQLDMO. Can it be done? Can someone drop an example if it can.

Thanks,
Sean

[Nicholas Paldino [.NET/C# MVP]]

Re: List of SQL Servers

Sean,

You can also call the NetServerEnum API, passing in a filter of
SV_TYPE_SQLSERV ER to get all the SQL servers on the network. This is
probably EXACTLY what SQLDMO does.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard. caspershouse.co m

"Sean McKaharay" <sean.mckaharay @expoexchange.c om> wrote in message
news:udEsmKfrDH A.644@TK2MSFTNG P11.phx.gbl...[color=blue]
> I am trying to find a way to return a list of my sql servers other then
> using SQLDMO. Can it be done? Can someone drop an example if it can.
>
> Thanks,
> Sean
>
>
>
>[/color]