NetServerEnum for sqlExpress

[j-in-uk]

I am using NetServerEnum to get a list of sqlserver databases in my c#
code. I notice it does not return sqlexpress databases. What can I use
to get a list of all sqlservers?

Thanks

 

[Mattias Sjögren]

I am using NetServerEnum to get a list of sqlserver databases in my c#

code. I notice it does not return sqlexpress databases. What can I use
to get a list of all sqlservers?

Haven't tried it myself, but if you're targeting .NET 2.0 you can try
using the SqlDataSourceEnumerator class instead and see if its result
set includes Express versions.


Mattias

 

[Mark Rae]

Haven't tried it myself, but if you're targeting .NET 2.0 you can try
using the SqlDataSourceEnumerator class instead and see if its result
set includes Express versions.

Seems to be a bit sporadic...
http://www.google.co.uk/search?sour...-28,GGLG:en&q=SqlDataSourceEnumerator+express