YesYesYesYesYES... On both.
How many times have we gone out to the websites looking for the solution to a problem and seen the line "This fix is only for X problem, don't install if your mother has blue hair and the bathroom sink is backing up because the fix may cause more problems"? (Or something of the sort).
They don't put that warning on service packs and the fact that they put it on hot fixes tells me that they don't trust the hot fix code to completely resolve the issue without causing more problems. So then why why why are they not verifying this code and rolling it up in a Service Pack?
Then there's the problem of the server admin who have bad hot fix experiences so refuse absolutely to put in a hot fix unless it's either critical or a service pack. And in a big corporation, SQL Server ends up getting the short end of the patch fixing. Oh, they'll patch the OS that SS is installed on, but we'll wait until the patches are all put in an SP before we fix SQL Server. I can't blame them. I don't want to install a patch, bring the server down and spend the next 72 hours rebuilding it back to it's pre-patch status.
So why isn't Microsoft aware of this behavior in the marketplace? Yes they can make money selling to the non-tech people on the basis that the software will fix all the problems (There's a Dogbert storyline in this), but if the techs refuse to apply the software or keep complaining, MS is eventually going to lose money. Look at all the people fleeing to Open Source.
So, yes, absolutely. They should provide regular service packs and always give a "final" service pack for which ever product they're about to stop supporting. With 2008 being pushed further and further back, they're going to have to do something about 2000 or risk a lot of marketplace anger for dropping 2000 support and not truly supporting 2005.
Thanks my $.02 rant. Thanks for letting me borrow your soapbox.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.