Systems Engineering and RDBMS

« How to Videos and E-Books
1TB Drives for Arrays »

Some important bug fixes for SQL Server 2005

Posted by decipherinfosys on February 18, 2008

We ran into a couple of issues while helping one of our clients and were researching the fixes for those issues and it turns out that the fixes for those are available in some of the cumulative updates so we thought we would share them with you. If you do not do so already, you should keep an eye out on the bug fixes that are released by MSFT in the cumulative updates. You can look at KBalertz.com and can subscribe to the automatic notifications so that you do not spend too much time troubleshooting issues that are really bugs in the product that have already been reported and fixed by MSFT.

Here are some that we found while working for our client:

FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: “A severe error occurred on the current command”

FIX: Some rows are not returned when you run a complex query that uses the DISTINCT keyword in Microsoft SQL Server 2005

FIX: A blocking issue occurs when you update rows in a table in SQL Server 2005

FIX: A stored procedure cannot finish its execution in SQL Server 2005

This entry was posted on February 18, 2008 at 12:48 pm and is filed under SQL Server. . You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

One Response to “Some important bug fixes for SQL Server 2005”

  1. Log Buffer #85: a Carnival of the Vanities for DBAs Says:
    February 22, 2008 at 5:54 pm

    [...] Systems Engineering and RDBMS reports on some important bugfixes in this update. [...]

Comments are closed.

« How to Videos and E-Books
1TB Drives for Arrays »