Returns the name of the registry key under which SQL Server is running. @@SERVICENAME returns ‘MSSQLSERVER’ if the current instance is the default instance; this function returns the instance name if the current instance is a named instance.
Transact-SQL Syntax Conventions
@@SERVICENAME
nvarchar
SQL Server runs as a service named MSSQLServer.
The following example shows using @@SERVICENAME
.
SELECT @@SERVICENAME AS 'Service Name';
Here is the result set.
Service Name
------------------------------
MSSQLSERVER
Configuration Functions (Transact-SQL)
Manage the Database Engine Services