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

Deleting Columns From a Table with a Query in MS SQL

What is Failover Clustering in SQL Server ?

What is RAISEERROR in SQL Server ?

What is the XML Datatype in SQL Server ?

What are the INTERSECT Operators in SQL Server ?