Showing Server Active Server Name in MS SQL

203 Reads Ms Sql

The following query should be run to show the active Server name in MS SQL Server.

SELECT @@SERVERNAME AS ServerName
Ms Sql

You May Interest

What are Replication and Database Mirroring in SQL Server ?

MS SQL Getting List of All Column Names of a Table

What is NOLOCK Hint in SQL Server ?

What are the Authentication Modes in SQL Server ?

What is a View in SQL Server ?