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 is CHECKPOINT Process in the SQL Server ?

What is the XML Datatype in SQL Server ?

What is the Difference Between VARCHAR and VARCHAR(MAX) Datatypes ...

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...

Disabling All Constants in a Table in MS SQL