Sign in

    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:

      92.5 MB

      167.0 MB

      130.2 MB

      KB Articles: KB934459

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