List of SQL Servers

  • Thread starter Thread starter Sean McKaharay
  • Start date Start date
S

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
 
Sean,

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

Hope this helps.
 
Back
Top