Home Forums SQL Server 2005 Administering Change company name in SQL Server 2005 RE: Change company name in SQL Server 2005
Cath Trimble
SSCarpal Tunnel
Points: 4201
More actions
February 3, 2011 at 3:21 am
#1281783
crazy4sql, if you look in BOL at the topic How to: Rename a Stand-Alone Instance of SQL Server 2005, you'll see that
sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
is exactly how to do it. As I have many times.