Thursday 8 November 2012

How to change SQL Server Instance Name?

First collect the output of the current instance configuration

sp_helpserver
select @@servername

Execute the below query to change the instance name:

sp_dropserver ‘old_name’
go
sp_addserver ‘new_name’,‘local’
go

Verify sql server instance configuration by running below queries:


sp_helpserver
select @@servername

No comments:

Post a Comment