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