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

  • Thread starter Thread starter 12jumper
  • Start date Start date
1

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.
 
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.
Click to expand...
---
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
 
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.
Click to expand...
---
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
 
Visual Studio 2005 provides that functionality in the System.Data.SQL
namespace. That way you don't have to use com ; )
 
Back
Top