04.03.2007 - Critical Update for Microsoft SQL Server 2005 Service Pack 2 (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. - Download Microsoft SQL Server 2005 SP2 - View Microsoft Knowledge Base Article - 934458 - Visit Microsoft Corporation