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...


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.

  • +1, but I am not with you on the following: "if you are not affected by bugs you do not know about, they may as well not exist, right? " The reason: some problems do not show up right away. They are in fact time bombs, causing trouble later. An example: Columnstore Index Returns Incorrect Data - it only makes itself visible when several stars are aligned, right?
    – A-K
    Sep 21 '12 at 13:25
  • @Alex That depends on how far you are pushing SQL Server 2005 today and how likely you are to come across some new bug that nobody has ever discovered before. That is far more likely to occur in a new feature in a new version than the most popularly deployed version on the planet, where all known "incorrect results" bugs have been fixed. Do you know of any incorrect results bugs that have not been fixed? Do you know if there are any bugs that haven't been fixed but haven't been disclosed? Sep 21 '12 at 13:28
  • @AaronBertrand Thanks for the detailed and very well thought out comment. I think you are correct that the likelihood of an "incorrect result" bug still existing on 2005 is very small (which is one reason I like being a version or two back). It also makes perfect sense that Microsoft would not be vested in trying to maintain such a list. I was actually hoping a third party might be. My guess is that alot of people are still on 2005, and will be for several years (in developing countries, perhaps even longer). Anyway, thanks for the great reply (and to Alex and Shawn as well). Sep 21 '12 at 22:20
  • @AaronBertrand Actually, your suggestion to use the Connect site might give me what i want - even if the bugs were fixed in a later version, I don't care (I just want to see any that remain in 2005). But, does that site contain all known bugs, or just those opened by the community (i.e. what about bugs discovered internally at Microsoft and release in a KB or something?). (and, yes, I am back looking at this 4 years later ... still a frustrating issue) Jun 30 '16 at 19:53
  • @Scott No, Microsoft doesn't use Connect to document internally found bugs, or even externally found bugs raised by customers but not through Connect. Jun 30 '16 at 20:59

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.