How to Rename SQL Server Instance Name

preview_player
Показать описание
In this video you will learn how to rename SQL Server instance using T-SQL Script in Telugu.

Queries:

USE MASTER
GO
EXEC [MASTER]..SP_DROPSERVER 'OLD SERVER NAME'

EXEC [MASTER]..SP_ADDSERVER 'NEW SERVER NAME', 'LOCAL'
Рекомендации по теме
Комментарии
Автор

Hi bro nice explaination. SQL server DBA ki sambandhinchina videos annitiki oka playlist lo pettandi bro.maaku download cheskovadaniki easy ga untundhi.topic wise kaakunda oke playlist lo pettandi plz.

gvhkrishna
Автор

Hi..good evening! I am Lakshmanarao Could you please clarify my Question, my Question is list out server list(instance names) in (ex:192.186.30.20) server

dasarilakshmanarao
Автор

This is sever name update, not instance name update

Lets_chillout
Автор

I have followed the steps above, and when I run the command Select * from sys.sysservers I can see my new server name. But when I login to SSMS I am still loging in with my old server name. So what additional steps do I need to take so my new server name is effective?

ubellubo
Автор

POINTLESS ! Title says Rename INSTANCE NAME whereas you are changing the SERVER NAME !!!

Madjidnoukfadou
Автор

Kindly try ur self 1st after that u will make video

It's not working Mr 😎

bijayalaxminayak