CODE EXAMPLE FOR SQL

how to change server name in sql server

-- How to change server name in sql server (complete guide)?
-- It's only for PCs not having Windows Server installed.

-- Steps:
-- 1. Execute below to drop the current server name

	EXEC sp_DROPSERVER 'old_server_name'
    
-- 2. Execute below to add a new server name. Make sure local is specified.

	EXEC sp_ADDSERVER 'new_server_name', 'local'
    
-- /* Hey! it's making, two server names locally. Totally shocked...!!! */

-- 3. Restart SQL Services from ***SQL Server 2016 Configuration Manager***.

-- 4. Verify the new name using:

	SELECT @@SERVERNAME
	SELECT * FROM sys.servers WHERE server_id = 0
    
-- I must point out that you should not perform rename if you are using:

	-- 1. SQL Server is clustered.
	-- 2. Using replication.
	-- 3. Reporting Service is installed.