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

Creating a Stored Procedure in MS SQL

Disabling a Specified Trigger in MS SQL Server

What is the Maximum Size per Database for SQL Server Express ?

Disadvantages of Using Stored Procedures in MS SQL

What is the Merge Statement in SQL Server ?