SQL Server 2005 versions

[Dukester0122]

I'm moving all our SQL Servers and is now half-way. While we were doing I tried to check the versions and found that the old & new had different SP2 installed. The old server was in 9.0.3054 while the new servers were in 9.0.3042.

I know these are different versions of SP2, can I just install SP2 again so it gets to 9.0.3054. Is it that easy?

 

[mrdenny]

9.0.3054 is SP2 plus a hotfix. Specifically it is the hotfix from MSKB 934458.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog