Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Maintenacne Plan & TSQL Query

Author  Topic 

khanewal
Starting Member

33 Posts

Posted - 2010-11-25 : 23:42:14
Hi Team,

if you help me out much appricated.

I am running DBCC Commadn

Query: DBCC CHECKDB ('ABC') WITH NO_INFOMSGS, ALL_ERRORMSGS;
SQL Logs: Date, Source, DBCC CHECKDB (abc with all_erromsgs bala bala)

wheny I run Integrity Plan from SSMS if there are three user DB its check also Master three times,

not sure why Maintenance plan is not working as TSQL Command ??

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-26 : 00:32:31
Why bother with a maintenance plan if you have a working T-SQL script?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

khanewal
Starting Member

33 Posts

Posted - 2010-11-26 : 01:14:54
Found the Solution

http://support.microsoft.com/kb/934458

Bug in SQL SERVER 2005 Builds 3042
Go to Top of Page
   

- Advertisement -