Tag Archives: renaming

After renaming the server, run the following:

--After renaming the physical server , run the following:
-----------------------------------------------------------------------------------------------------
master.dbo.master.dbo.sp_dropserver 'oldServerName'
GO
master.dbo.sp_addserver 'newServerName', 'local'
GO
--Restart the SQL instance at this point.
-----------------------------------------------------------------------------------------------------

--After restarting, run the following to confirm that the previous was successful. Is should return the new server name.
-----------------------------------------------------------------------------------------------------
SELECT @@SERVERNAME AS 'Server Name'
-----------------------------------------------------------------------------------------------------
Tagged ,