Change Instance name on Server

• Imke Cronje

  SSCarpal Tunnel

  Points: 4826

  More actions

  August 19, 2008 at 9:17 am

  #124798

  Hi there,

  When I run the select serverproperty ('InstanceName') on one of our servers, I get a NULL value.

  how can I change the result to get SQL2005.

  I have tried the code below...but it does not work:

  Copy Code

  sp_dropserver

  GO

  sp_addserver , local

  GO

  Restart the SQL Server instance.

  Regards

  IC

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  August 19, 2008 at 9:26 am

  #860085

  from BOL 😉

  SERVERPROPERTY ( propertyname )

  InstanceName

  Name of the instance to which the user is connected.

  Returns NULL if the instance name is the default instance, if the input is not valid, or error.

  Base data type: nvarchar(128)

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉