Critical Update for SQL Server 2005 Service Pack 2

Select Language:
Download an update to SQL Server 2005 SP2. This update resolves an issue with saved "Check Database Integrity" and Execute T-SQL Task losing database context between GO statements
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


    File Name:




    Date Published:


    File Size:

    18.2 MB

    36.1 MB

    23.4 MB

    KB Articles: KB934458

      In SQL Server 2005 SP2, the Maintenance Plan "Check Database Integrity" and "Execute T-SQL" Tasks can lose database context under certain circumstances. If configured to check integrity on multiple databases, the Check Integrity Task repeatedly checks the default database. If an Execute T-SQL Task contains multiple batches, separated by GO statements, and does not include USE statements in each batch, those statements that don't provide a database name will be executed against the default database. Incorrect operation can be verified by setting up a profiler trace and observing the database column.
  • System Requirements
    Supported Operating System

    Windows 2000 Service Pack 4, Windows Server 2003 Service Pack 1, Windows Server 2003 Service Pack 2, Windows Vista, Windows XP Service Pack 2

    • Note: You must have administrative rights on the computer to install this update.

        Step 1: Review the KB article.

        Step 2: Download the appropriate package by clicking one of the links below. To start the installation immediately, click Run. To install this update at a later time, click Save.

        Note: Each package updates all SQL Server 2005 languages.

Site feedback

What category would you like to give web site feedback on?

Rate your level of satisfaction with this web page today: