Critical Update for SQL Server 2005 Service Pack 2
Brief Description
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
*Download size depends on selected download components.
Change Language:
Overview
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 Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows Server 2003 Service Pack 2; Windows Vista; Windows XP 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.
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.
