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 the Merge Statement in SQL Server ?

MS SQL Get Current Time GETDATE()

What are the Various Limitations of the Views in SQL Server ?

Deleting Table With Query in MS SQL

Creating a View in MS SQL