Backward Compatibility not checked in applying SP4
I've just downloaded SP4 for SQL Server 2005, and ran it against our test database. I noticed, while running it, that Backward Compatibility wasn't checked. Normally, when installing something like a service pack, I just take the default settings. I'd like to know why Backward Compatibility wasn't checked and what difference it makes by not checking it.
SQL Server 2005 is on its way out, the support ends on April 12th of this year. Of course, Microsoft will offer extended support for the product well past this end of support date, and I guess this is why they decided to have RTM release of SP4 out so late in the game. Backward Compatibility is probably not relevant, because the major part of the SP4 consists of 11 cumulative updates which have been out for some time, and do not include any features which need backward compatibility checks. Perhaps the other features included in SP4, such as some fixes requested by users on connect as well as engine support for DAC, do not require backward compatibility check either. The real question is that whether you will agree to risk installing the RTM release on the prod servers?