Search

Thursday, May 17, 2012

Rename SQL Server Instance Name

Run below queries to rename SQLserver Instance Name


sp_helpserver  
select @@servername  
go  
   
sp_dropserver 'OLDSNAME'  
go  
sp_addserver 'NEWNAME','local'  
go  
   
sp_helpserver  
select @@servername  
go  


Remember you have to restart the SQL Server service after executing this.

No comments:

Post a Comment