SQL @@SERVERNAME

SQL @@SERVERNAME 1

SQL @@SERVERNAME is one of the Configuration Function, which will return the local server name that is currently running SQL Server. Syntax behind this is @@SERVERNAME SQL @@SERVERNAME Example Below code snippet will show you the instance of the SQL Server that we are currently using. SELECT @@SERVERNAME AS ‘Server Name’