SQL @@SERVICENAME

SQL @@SERVICENAME 1

SQL @@SERVICENAME is one of the Configuration Function, used to return the registry key under which SQL Server is currently running. If it is a default instance, then it will write MSSQLSERVER as the service name, and if it is a named instance, then it will return the instance name. The syntax behind this is @@SERVICENAME SQL @@SERVICENAME Example … Read more