Upgrading to SQL 2005

[gavjb]

Hi,

I am in the process of looking a test upgrade from SQL2000 to SQL2005, once we are happy with the upgrade, we need to be able to turn off the SQL2000 and rename the SQL2005 server to the name of the SQL2000 server.

I know from experience with older version of sql server that this can be a pain to do, is it an easy task with sql2005 to rename a server?

 

[mrdenny]

It's just as easy with SQL 2005 as it is with SQL 2000.

exec sp_dropserver 'OldServerName'
go
exec sp_addserver 'NewServerName', 'local'
go
--Reboot

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[gavjb]

thanks that was what I was after

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com