Sql

Search

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.

Comment

PREVIOUS	NEXT

Code Example
Sql :: declare temp table in sql
Sql :: bigquery timestamp
Sql :: postegresql update to null
Sql :: sql server: how to concatenate column data using comma
Sql :: postgresql create table many-to-many
Sql :: install mysql in ubuntu 18.04
Sql :: drush SQLSTATE[HY000] [2002] No such file or directory
Sql :: sql distinct
Sql :: oracle alter table add column
Sql :: multiple order by sql
Sql :: export mysql table to file
Sql :: sql like case sensitive
Sql :: mysql decimal remove trailing zeros
Sql :: inner join mysql
Sql :: sqlalchemy get ids
Sql :: mysql dump
Sql :: C# mysql data reader from two tables
Sql :: min mysql
Sql :: oracle job class
Sql :: missing left parenthesis error in sql
Sql :: sql numeric data type
Sql :: get specific column in mongodb
Sql :: mql5 list all available symbols
Sql :: how to delete python anywhere mysql database
Sql :: how to set all the time serveroutput on in oracle sql developer
Sql :: mssql now diff 90 day
Sql :: tablo silme SQL
Sql :: How to create a comulative Sum column in mysql
Sql :: import mysql command line
Sql :: db count rows

Search

SQL

how to change server name in sql server

ADD CONTENT