Get the actual server name of the current SQL Server. Useful when you are using listeners to connect into SQL Server and need to know the exact server name you are connected into.

SELECT @@SERVERNAME

Last modified: May 7, 2019

Author

Comments

Write a Reply or Comment