List of available SQL servers in the network (SQL Server 2005)

[12jumper]

I'd like to present such list to an user, I've tried to use SQLDMO, but
for some reason it shows only the server which is running on my
machine. I know, that there is a couple of threads concerning this
issue, but solutions described there don't work. Any help will be
greatly appreciated.

 

[Michael Nemtsev]

Hello (e-mail address removed),

What's wrong? Have u read this KB http://support.microsoft.com/kb/q287737/

I'd like to present such list to an user, I've tried to use SQLDMO,
but for some reason it shows only the server which is running on my
machine. I know, that there is a couple of threads concerning this
issue, but solutions described there don't work. Any help will be
greatly appreciated.

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

 

[Michael Nemtsev]

Hello (e-mail address removed),

C# sample http://www.sqldbatips.com/showarticle.asp?ID=45

I'd like to present such list to an user, I've tried to use SQLDMO,
but for some reason it shows only the server which is running on my
machine. I know, that there is a couple of threads concerning this
issue, but solutions described there don't work. Any help will be
greatly appreciated.

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

 

[Guest]

Visual Studio 2005 provides that functionality in the System.Data.SQL
namespace. That way you don't have to use com ; )