Thursday, May 14, 2009

Changing the name of a SQL Server

After changing the computer name on a MS SQL Server you will need to run the following SQL query:

 

sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO

Posted by at
Labels:

3 comments:

Subscribe to: Post Comments (Atom)