THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Browse by Tags

All Tags » Maintenance » Tools   (RSS)
Sorry, but there are no more tags available to filter with.
  • 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). I created a plan to do CHECKDB against all databases, and this is what I found in my errorlog ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 8, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement