renameing the instance | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

renameing the instance

Hi folks, I’ve SQL Server loaded in system called ‘DATASERVER’. But, the SQL Server name is ‘DS’. (i.e.. When I use @@SERVERNAME it is giving ‘DS’. And if I use SERVERPROPERTY(‘servername’) it is giving ‘DATASERVER’). Now, I wanted to make the SQL Server name as System name,ie., ‘DATASERVER’. Any guess……. Rajendar
ok
Check: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1137 HTH Luis Martin
Moderator
SQL-Server-Performance.com
BOL specifies :
Although the @@SERVERNAME function and the SERVERNAME property of SERVERPROPERTY function may return strings with similar formats, the information can be different. The SERVERNAME property automatically reports changes in the network name of the computer. In contrast, @@SERVERNAME does not report such changes. @@SERVERNAME reports changes made to the local server name using the sp_addserver or sp_dropserver stored procedure.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>