Return Current Connection CName I'm wondering if anyone knows if there is a way to return the name that was used to connect to the SQL server rather than the actual server's name. For instance I typically connect to the server via a DNS CName. But if I run this ..
select @@SERVERNAME

... I get the actual server name. I'm looking to find a way to get the CName with which I connected if it is even possible. Thoughts?
The SQL Server instance has no notion of the name resolution the client used to connect to the server IP address so what you want is not possible.
@@SERVERNAME returns the server name or FCI network name, plus instance name for a named instance. The value is unrelated to the client connection specification.