|
Critical Update for SQL Server 2005 Service Pack 2 |
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
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.
| Knowledge Base Articles: |
|---|
Files
|
Status: DeletedThis download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to May 2019. |
System Requirements
Operating Systems: Windows XP Service Pack 2, Windows 2000 Service Pack 4, Windows Vista, Windows Server 2003 Service Pack 1, Windows Server 2003 Service Pack 2
For additional information on the version of SQL Server 2005 SP2 this update applies to please refer to Knowledge Base (KB) article 934458.
Installation Instructions
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.