Thursday, April 20, 2006

Microsoft SQL Server 2005 Service Pack 1

It's been a whole day now, since SQL Server 2005 SP-1 has been made available for download.

The build number is 2047 (v. 9.00.2047).

Read the list of changes and fixes before attempting an upgrade.

I've installed the CTP when it was first made available, so I guess I'm looking at a uninstall/reinstall weekend. :)

Oh, yes - SQL Server 2005 Express and Express with Advanced Services have also been made available.

I'll have to start the weekend MTV-style - 8:00 AM Friday morning.


Warning:
You may run into some difficulties when upgrading SQL Server Express to the Advanced Services Edition.

Thanks to Andrej Tozon (links) here are two links to help you out:


ML


p.s. The registry key that needs to be empty prior to installing SQL Server:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations

No comments: