Identifying Service Packs

Don’t use SQL Server without service packs! We upgraded one node of our sql cluster to a faster computer, and when the network admin went to install SQL Server SP3 on it, it claimed that it didn’t need to do anything since it was a part of a cluster. When people started using the site, the CPU on the database shot up to 100% and we started mysterious getting SQL Server internal errors.

We eventually determined that even though Enterprise Manager was claiming that SP3 was installed, it wasn’t. This site and this KB article describe how to more accurately figure out service-package.

Today’s lessons are 1) don’t believe Microsoft and 2) don’t use any Microsoft product until they’ve patched it at least once!

Comments are closed.