How to Rename SQL Server Instance Name

In this video you will learn how to rename SQL Server instance using T-SQL Script in Telugu.

Queries:

SELECT @@SERVERNAME

USE MASTER
GO
EXEC [MASTER]..SP_DROPSERVER ‘OLD SERVER NAME’

EXEC [MASTER]..SP_ADDSERVER ‘NEW SERVER NAME’, ‘LOCAL’