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 Wait Types in SQL Server ?

What is Partial Cache Mode in SSIS ?

How to Rebuild the Master Database in SQL Server ?

Getting Character Count in MS SQL

What is Auditing Inside SQL Server ?