SQL Server Aggregator

Be aware: Sp2, maint plans and CHECKDB

Tony Rogerson brought to my attention that with sp2, a plan that does CHECKDB seems to always do it against the master database. Technicalities seems to be in how SSIS executes SQL commands, separates batches and connection pooling (sp_reset_connection). Read More...
Published Thursday, March 08, 2007 7:44 PM by Tibor Karaszi
Filed under: ,
Anonymous comments are disabled