control
SSCommitted
Points: 1630
More actions
September 30, 2003 at 5:59 am
#151939
Guys,
What is the best way to change an instance name on a server that has more than one instance of SQL Server 2000? Keep in mind the agent for that instance too.
Jonathan
SSC-Insane
Points: 20427
September 30, 2003 at 6:36 am
#476352
Backup your databases and then sp_dropserver, sp_addserver and restore.
See question 5 in:
http://support.microsoft.com/?kbid=260414
--Jonathan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply