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

List of Table Columns Used in Any View in MS SQL

MS SQL Restoring a Database With a Query

What is Change Data Capture in SQL Server ?

Getting List of All Views in MS SQL Database

Using MS SQL TOP