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

Making a MS SQL Offline Database Online

What is CHECKPOINT Process in the SQL Server ?

What is the Merge Statement in SQL Server ?

How is Change Tracking is Different From Change Data Capture ?

Deleting Table With Query in MS SQL