Showing Server Active Server Name in MS SQL

The following query should be run to show the active Server name in MS SQL Server.

SELECT @@SERVERNAME AS ServerName


You May Interest

What are the System Data Collection Sets Predefined Inside SQL Se ...

Using MS SQL COUNT

Getting the Id of MS SQL Server Last Entered Record

What is Utility Control Point (UCP) in SQL Server ?

Which TCP/IP Port Does the SQL Server Run On ?