SQL Server 2008 sp1 rollback

 
SQL Server 2008 Service Pack 1 includes a few features, and one that I am most interested in is the rollback feature.  Since we’re now in this 24-month rollout period of our favorite software, destined to bankrupt some or drive some crazy to the point of pulling their hair out, I figure that eventually something that gets churned out at this rate will no doubt be garbage and need to be rolled back. Alas! The ability to rollback a service pack!  As mentioned in a previous post, we have needed this for about a decade now, right? Anyway, I have a couple of SQL Server 2008 instances installed on my home workstation; rather than bed and tape bathrooms this early Sunday morning (home remodeling is really a pain) I opted to install SP1 and then remove one of them just for fun. Uh oh - hold the line.

Come to find out that it’s located in the Control Panel under Programs and Features. Uh, we don’t have “Programs and Features” in XP! (Vista and Windows Server 2008 only).   Then, I looked around and verified that the uninstall is only Vista and above, apparently. WTH?  Looking at SSMS, the install went ok.  Opening the Control Panel, I expected to find an entry for SQL Server 2008 sp1, but didn’t.

I need to research this further I guess. Makes no sense.

Lee