Sql Server Name

[A I]

Hi Friend,
Is there any way in SQL Server by which I can locate the names of all the SQL-servers on the network. I was wondering if I can execute some query on Master database to find the above info??? Any clues??

Thanks in advance
Wiz

[Anu]

isql -L from command prompt

-Anu


------------
A I at 7/10/01 5:37:19 PM

Hi Friend,
Is there any way in SQL Server by which I can locate the names of all the SQL-servers on the network. I was wondering if I can execute some query on Master database to find the above info??? Any clues??

Thanks in advance
Wiz

[Rachel]

Hi, I was just thinking about trying to get that same info. I've tried the isql -L cmd, but I know for a fact there are more MS SQL Servers than what was returned, How could this be?
Is there another method?
Thanks for help.


------------
Anu at 7/10/01 5:41:43 PM


isql -L from command prompt

-Anu


------------
A I at 7/10/01 5:37:19 PM

Hi Friend,
Is there any way in SQL Server by which I can locate the names of all the SQL-servers on the network. I was wondering if I can execute some query on Master database to find the above info??? Any clues??

Thanks in advance
Wiz