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.
| Author |
Topic |
|
Norwich
Posting Yak Master
158 Posts |
 Posted - 2006-03-14 : 07:26:04
|
| HIHow can I identify all the SQL servers on my network using T-SQL?@@ServerName will return the name of the box I'm running it from - I wan't the names of all the serverRegardsNThe revolution won't be televised! |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-14 : 07:48:54
|
| Try thisSelect srvName from Master..SysServersMadhivananFailing to plan is Planning to fail |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-14 : 08:02:55
|
| That won't give you all the servers unless you have links to them already..The only way I can suggest is to get all the ipaddresses and run a simple select to each via the command line.. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-03-15 : 06:07:54
|
quote:
Originally posted by khtan
Refer to here http://www.sqlteam.com/item.asp?ItemID=5403----------------------------------'KH'
Thanks for the linkRegardsNThe revolution won't be televised! |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-16 : 07:12:13
|
| If you have more than one domain, you will need to run any of these on each one.. |
|
|
|
|
|
|
Server ID?