![]() Critical Update for SQL Server 2005 Service Pack 2Brief DescriptionDownload 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 On This PageQuick Details
OverviewIn 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
InstructionsNote: You must have administrative rights on the computer to install this update.
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. Files in This DownloadThe links in this section correspond to separate files available in this download. Download the files most appropriate for you.
What Others Are DownloadingOthers who downloaded Critical Update for SQL Server 2005 Service Pack 2 also downloaded: |
||||||||||||||||||||||||||||