What known bugs still exist in SQL Server 2005 after SP4 CU4?

Posted on

Question :

I’m assuming CU4 will be the last update for SQL 2005. We intend to stay on 2005 for awhile. Does anyone know (or perhaps a list is maintained) which bugs STILL exist on 2005? I assume these would mainly be bugs that have been fixed in 2008 and 2012, but still exist in 2005, even after applying SP4 CU4.

Seems like we should track this if we are staying on 2005…

Answer :

Microsoft doesn’t really keep a public list of open bugs. The ones that are the most important (e.g. anything involving security) are kept private for obvious reasons – they actually aren’t published until they are fixed (and even then they often remain private). Not that there have been many security issues with SQL Server in the past 12 years, but by necessity, we don’t know what we don’t know.

And to be honest keeping such a list out in the open would be like BMW keeping a bulletin board with all the problems that still exist on their 2006 M3. It’s kind of like a dirty laundry list, and other than satisfying customers who refuse to upgrade to more modern (and arguably “more fixed”) versions, what would it do for them? 🙂

Now, you could go out to http://connect.microsoft.com/sql/ and peruse the list of bugs opened against SQL Server 2005 that are still open. But that wouldn’t be the whole story, since many bugs were opened against 2005, then closed as fixed when the fix was actually implemented in a more modern version. Never mind the large number that were closed as by design or not reproducible but that still affect you to this day.

You could also go to the knowledge base http://support.microsoft.com/kb and try to find all of the issues listed there that haven’t been updated to include the text “this issue has been fixed in [such and such update].” This would also be a Herculean task that I would not wish against my worst enemies.

In the end, if you are not affected by bugs you do not know about, they may as well not exist, right? And if you are continuing active development against SQL Server 2005 and you come across an issue, it is highly, highly unlikely that you will be the first person to come across it. So if you come here for assistance you will stand a very good chance at getting the guidance you need – either a workaround to get around the bug by coding the query a different way, or a trace flag, query hint, or a completely different approach.

I know this isn’t the answer you’re looking for, but I’m quite afraid you’re not going to get the answer you’re looking for. This answer (and this site, to be honest) is quite possibly the next best thing. When you have a specific issue, bring it here, and we will help.

100% agreement with @Aaron on this.

Athough your comment Seems like we should track this if we are staying on 2005... strikes a chord with most folks I am sure…

You should not be planning to stay on SQL Server 2005, that follows the normal lifecycle support Microsoft has for everyone of their products. This goes along with what Aaron spoke of regarding bugs that are marked fixed in the next release, be it SQL 2008, 2008 R2 or even 2012. The same fate is meet with the operating system as well. If you move your SQL 2005 instance to each new release of the OS you are going to hit a release that will not support SQL 2005 being run on it.

That is just the normal business planning that has to be considered when working in a Windows environment, and if you work in other environments as well I am sure.

Leave a Reply

Your email address will not be published. Required fields are marked *