Searching SQL Servers

[GysE]

I'm new as a DBA for a big company. I must do an audit to see how many SQL servers are there in the company.
I know about the facility where you register new SQL servers to click on a button and you will get all the active SQL servers. But this option does not give you a list of all servers.

Is there perhaps a command/tool/utility that will list all SQL servers in my entire company? I’m only interested in the server side and not the client side.

 

[JFoushee]

This may be a round-about way of doing this, but in Enterprise Manager, use the wizard to add a new SQL Server.

(Go to Tools, Wizards..., and select the "Register Server Wizard". After this, make sure the checkbox is UNchecked to proceed. Click Next.)

In this screen, you should see a list of available servers on the left, and a list of to-be-registered servers on the right.

Unfortunately, my list on the left doesn't populate because I'm not on the same network as the SQL Servers.

I hope it helps in your case.

 

[tlbroadbent]

Try OSQL -L from the command line. According to SQL BOL, the -L option "Lists the locally configured servers and the names of the servers broadcasting on the network."

You can also use SQLDMO. See the SQL FAQ at

http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14327.

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.