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

Generating Random Letters in MS SQL

MS SQL Compiling a Stored Procedure With a Requery

What is an Index in SQL Server ?

What is Change Data Capture in SQL Server ?

What is TABLESAMPLE in SQL Server ?