The Active Network
ActiveMac Anonymous | Create a User | Reviews | News | Forums | Advertise  
 

  *  

  Critical Update for SQL Server 2005 Service Pack 2 builds 3150 through 3158 (KB934459)
Time: 09:50 EST/14:50 GMT | News Source: ActiveWin.com | Posted By: Jonathan Tigner

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.

Also available:

Write Comment
Return to News

  Displaying 576 through 576 of 576
Prev | First
  The time now is 1:28:00 AM ET.
Any comment problems? E-mail us
#576 By 4240821 (82.115.4.230) at 7/21/2025 12:14:54 AM
https://justpaste.me/axl65
https://justpaste.me/cRGe1
https://justpaste.me/dLK22
https://justpaste.me/cVMT2
https://justpaste.me/a8Oy
https://justpaste.me/aNFP4
https://justpaste.me/bbvQ3
https://justpaste.me/avLK1
https://justpaste.me/b04u
https://justpaste.me/bS6j2

Write Comment
Return to News
  Displaying 576 through 576 of 576
Prev | First
  The time now is 1:28:00 AM ET.
Any comment problems? E-mail us
User name and password:

 

  *  
  *   *