Implications of renaming sql server 2000 instance

Posted by peg_leg on Server Fault See other posts from Server Fault or by peg_leg
Published on 2011-01-31T15:03:44Z Indexed on 2011/01/31 15:27 UTC
Read the original article Hit count: 287

I have a sql server 2000 of which I want to replicate the data to a sql server 2008. However the output from select @@servername and select serverproperty('servername') on the 2000 server are different and that prevents replication. There is a process to resolve this at http://support.microsoft.com/kb/818334 . Has anyone done this? What implications are there for following this process? Any 'gotchas' that need to be guarded against? My 2000 server is a lone production server...very scary. Please advise.

© Server Fault or respective owner

Related posts about replication

Related posts about sql-server-2000