SSTS Blog
Some news and tidbits that we share
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
Comments
Please login first in order for you to submit comments