service name

• Satya_0000

  Mr or Mrs. 500

  Points: 544

  More actions

  January 13, 2012 at 3:31 am

  #249607

  is thereany difference between @@servicename and @@servername?

• derek.colley

  SSCrazy Eights

  Points: 8040

  More actions

  January 13, 2012 at 3:36 am

  #1433119

  I believe these variables will be different if you have a named, not a default, instance.

  I may be wrong.

  EDIT: No, I was right.

  select @@servername returns... <SERVER>\<INSTANCE>

  select @@servicename returns... <INSTANCE>

  ---

  Note to developers:
  CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
  So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

  Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
  My blog: http://uksqldba.blogspot.com
  Visit http://www.DerekColley.co.uk to find out more about me.

• padhis

  SSCommitted

  Points: 1762

  More actions

  January 13, 2012 at 3:36 am

  #1433121

  @@servicename-Returns the name of the registry key under which SQL Server is running.

  @@servername-Returns the name of the local server that is running SQL Server.