Wednesday, March 17, 2010

Renaming an SQL Server 2008 Instance

From:

– Get the current name of the SQL Server instance for later comparison.
SELECT @@servername

– Remove server from the list of known remote and linked servers on the local instance of SQL Server.
EXEC master.dbo.sp_dropserver '[SERVER NAME]'

– Define the name of the local instance of SQL Server.
EXEC master.dbo.sp_addserver '[NEW SERVER NAME]', 'local'

– Get the new name of the SQL Server instance for comparison.
SELECT @@servername

Note: be careful of the quotes, they should be single quotes instead of the fancy ones mentioned on the blog.

No comments: