Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Retrieve Names of all the names of servers in the network

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-24 : 18:04:17
aparna writes "Dear SQL Team

Please tell me how do i get the names of all the servers in the network
Please Help

Urs Faithfully
Aparna
aparnavkamath@hotmail.com"

nr
SQLTeam MVY

12543 Posts

Posted - 2002-03-24 : 19:50:51
Look at NetServerEnum with SV_TYPE_SQLSERVER.

==========================================
Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -