Servers

    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.
      Version:

      1.0

      File Name:

      SQLServer2005-KB934459-x86-ENU.exe

      SQLServer2005-KB934459-IA64-ENU.exe

      SQLServer2005-KB934459-x64-ENU.exe

      Date Published:

      4/3/2007

      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.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

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

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial