SSTS Blog

Some news and tidbits that we share

Renaming a SQL Server instance

by SSTS
SSTS
Server Side Technology Solutions is a consulting firm that specializes in databa
User is currently offline
on Jun 03 in Blog 0 Comments

Once in a while it may become necessary to rename an instance of SQL Server. Because this isn't something that you do frequently it's easy to forget the commands. It's just a couple of commands (see below) followed by a restart of SQL Server.

 

exec master.dbo.sp_dropserver ''

exec master.dbo.sp_addserver '', 'local'

 

now, Restart SQL Server

Tags: Untagged
Hits: 5730

About the author

SSTS

Server Side Technology Solutions is a consulting firm that specializes in database design, development and support.

Comments

Please login first in order for you to submit comments