Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
@@SERVICENAME
Return Types
nvarchar
Remarks
SQL Server runs as a service named MSSQLServer.
Examples
The following example shows using @@SERVICENAME.
SELECT @@SERVICENAME AS 'Service Name'
Here is the result set.
Service Name
------------------------------
MSSQLSERVER
See Also
Reference
Configuration Functions (Transact-SQL)
Other Resources
Managing the Database Engine Services