Main Menu

SSTS Blog

Some news and tidbits that we share

Renaming a SQL Server instance

by SSTS 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

Author

About the author

SSTS

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

http://www.serverside-ts.com

Comments

Please login first in order for you to submit comments

Lower Your Costs

Lower the costs of your DBA while ensuring that you have the quality that your company needs to remain successful and optimized!

24 x 7 Monitoring

For things that are essential to your success, do not let potential hazards stand in the way. With our 24x7 Monitoring Alert System, we can make sure your systems are always running as efficiently as they should be, even if you're sleeping.

Get A Solution

We have extensive experience in the field which allows us to approach every situation head on and find the best solution quickly. Our solutions are custom tailored to your needs. We will work with you in coming up with a services agreement that fits your needs.

Solutions...