 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008Access logical server name
The connection to our SQL servers is determined by a logical name, which points to a physical server. For example, the physical server name is SERVER1, but when we connect, we connect to a server called ProdServer, which points to SERVER1. When I connect to ProdServer via T-SQL or SSIS, when I issue the SELECT @@SERVERNAME command, the value returned is the name of the physical server. Is there a way via T-SQL to obtain the name of the logical server? No. The SQL Server doesn't know what name you used to connect to it. It only knows what it's physical name is. Denny >The connection to our SQL servers is determined by a logical name, which >points to a physical server. For example, the physical server name is [quoted text clipped - 5 lines] > >Is there a way via T-SQL to obtain the name of the logical server? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.