finding out instance name using reg query

• appalaraju_k-596051

  Old Hand

  Points: 323

  More actions

  January 12, 2011 at 4:35 am

  #230028

  Hi All,

  can any one help how to find out the instance name of the server by using reg query?

  Help appreciable!!

  Thanks.

• WayneS

  SSC Guru

  Points: 95405

  More actions

  January 12, 2011 at 4:48 am

  #1272284

  SELECT ServerName = @@servername,

  InstanceName = CASE WHEN CharIndex('\', @@ServerName) = 0 THEN NULL

  ELSE SubString(@@ServerName, CharIndex('\', @@ServerName)+1, 100) END;

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• Geoff A

  SSChampion

  Points: 11511

  More actions

  January 13, 2011 at 11:03 am

  #1273195

  if by reg you mean Registery

  Exec xp_regenumvalues N'HKEY_LOCAL_MACHINE',

  N'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL';

• Elliott Whitlow

  SSC Guru

  Points: 102296

  More actions

  January 13, 2011 at 12:32 pm

  #1273236

  I am fundamentally opposed to going to the registry unless it is ABSOLUTELY necessary.. And in this case it isn't..

  SELECT InstanceName = SERVERPROPERTY('InstanceName')

  It will return NULL for a default instance..

  CEWII