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:

      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.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Sign up for OneDrive and get 15 GB of free online storage.
    OneDrive now comes with 15 GB of free online storage
    Get more space for all your photos, videos, and documents.
    Sign up now