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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-14 : 09:39:56
|
| Vinod Kumar writes "I need to get a list of server aliases, network library, connection properties and server name from the SQL Server Client Network Utility application. I have over 40 SQL servers that I now maintain and logging on to each machine and executing the utility to write down what I found does not sound like a good time to me. Is there a SQL script or utility that I can run from my management\master SQL Server? or a script I can execute on each SQL instance that will return this list?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-09-14 : 09:47:41
|
| It makes no sense to connect to SERVERS in order to gather CLIENT network settings. Client aliases are meaningless on a SQL Server, unless they are used to set up linked servers, and that's an easily breakable feature.Anyway, you can find the client aliases in the computer's registry under:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo |
 |
|
|
|
|
|
SQL Server Client Network Utility alias List