unable to get the correct service name using registry query

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  May 22, 2015 at 12:16 pm

  #300949

  DECLARE @DBEngineLogin VARCHAR(100)

  DECLARE @AgentLogin VARCHAR(100)

  EXECUTE master.dbo.xp_instance_regread

  @rootkey = N'HKEY_LOCAL_MACHINE',

  @key = N'SYSTEM\CurrentControlSet\Services\MSSQLServer',

  @value_name = N'ObjectName',

  @value = @DBEngineLogin OUTPUT

  EXECUTE master.dbo.xp_instance_regread

  @rootkey = N'HKEY_LOCAL_MACHINE',

  @key = N'SYSTEM\CurrentControlSet\Services\SQLServerAgent',

  @value_name = N'ObjectName',

  @value = @AgentLogin OUTPUT

  SELECT [DBEngineLogin] = @DBEngineLogin, [AgentLogin] = @AgentLogin

  OR

  SELECT servicename, service_account

  FROM sys.dm_server_services

  Please suggest a query to get the exact servername ( do not want to use @@servername), either need to use registry to read or using DMV

  Thanks.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 22, 2015 at 1:21 pm

  #1800138

  Why the restriction?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 22, 2015 at 1:23 pm

  #1800139

  And what are you expecting to be returned?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 22, 2015 at 1:34 pm

  #1800141

  Here are two ways to get the servername:

  select srv.name as ServerName from sys.servers srv where srv.server_id = 0;

  select SERVERPROPERTY('ServerName');