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
 SQL Server Administration (2005)
 db integrity

Author  Topic 

DBA007
Posting Yak Master

145 Posts
Posted - 2010-03-26 : 13:36:47
my database integrity job has failed,stating the below iam using the script for this i found in viewhistory as

Service Broker Msg 9675, State 1: Message Types analyzed: 14. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9667, State 1: Services analyzed: 3. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9668, State 1: Service Queues analyzed: 3. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. [SQLSTATE 01000] (Message 8997) DBCC results for 'sys.sysrowsetcolumns'. [SQLSTATE 01000] (Message 2536) There are 714 rows in 7 pages for object "sys.sysrowsetcolumns". [SQLSTATE 01000] (Message 2593) DBCC results for 'sys.sysrowsets'. [SQLSTATE 01000] (Message 2536) There are 104 rows in 1 pages for ... The step failed.

and on the output to a textfile i found nothing except statements of these type

There are 1 rows in 1 pages for object "sys.sysrts". [SQLSTATE 01000]
DBCC results for 'sys.sysconvgroup'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysconvgroup". [SQLSTATE 01000]
DBCC results for 'sys.sysdesend'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysdesend". [SQLSTATE 01000]
DBCC results for 'sys.sysdercv'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysdercv". [SQLSTATE 01000]
DBCC results for 'sys.syssingleobjrefs'. [SQLSTATE 01000]
There are 1477 rows in 11 pages for object "sys.syssingleobjrefs". [SQLSTATE 01000]
DBCC results for 'sys.sysmultiobjrefs'. [SQLSTATE 01000]
There are 102 rows in 1 pages for object "sys.sysmultiobjrefs". [SQLSTATE 01000]
DBCC results for 'sys.sysdbfiles'. [SQLSTATE 01000]

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2010-03-26 : 14:29:58
Run DBCC CHECKDB in a new query window to see the full output. The job history doesn't provide enough room to see the whole thing. You can configure the job step to write more output just not in the job history.

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

Subscribe to my blog
Go to Top of Page

DBA007
Posting Yak Master

145 Posts
Posted - 2010-03-26 : 18:41:13
this is a prod server and dbcc checkdb dosent gave any errors all dbs have executed with out errors
Go to Top of Page

DBA007
Posting Yak Master

145 Posts
Posted - 2010-03-26 : 18:42:38
and this integrity job is failing once in two or three days other time it was working fine
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2010-03-26 : 19:59:02
If DBCC CHECKDB isn't showing any errors on any databases, then the job isn't working properly. Is it through a maintenance plan?

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

Subscribe to my blog
Go to Top of Page

DBA007
Posting Yak Master

145 Posts
Posted - 2010-03-29 : 10:16:07
no tara,iam using the scripts which you have specified in your blog,the job was executing two or three times in a week and failing remaining days,it has executed on saturday&sunday and it failed today,it shows error message as above of my first mail
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2010-03-29 : 13:42:17
You'll need to log the job step's output to a file then to get the full output on failure.

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

Subscribe to my blog
Go to Top of Page

DBA007
Posting Yak Master

145 Posts
Posted - 2010-03-29 : 14:44:35
tara,hear there is no attachment option available iam pasting the sample output or you can see the attchment on this link
http://www.sqlservercentral.com/Forums/Topic890927-146-2.aspx

There are 34 rows in 1 pages for object "Billing.psiActivityTypeTRC". [SQLSTATE 01000]
DBCC results for 'fwkGroupXLocation'. [SQLSTATE 01000]
There are 103026 rows in 443 pages for object "fwkGroupXLocation". [SQLSTATE 01000]
DBCC results for 'Billing.accLicenseModel'. [SQLSTATE 01000]
There are 6 rows in 1 pages for object "Billing.accLicenseModel". [SQLSTATE 01000]
DBCC results for 'rteRateCardTemplateStatus'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object "rteRateCardTemplateStatus". [SQLSTATE 01000]
DBCC results for '[!DELETE_fwkStatementLog]'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "[!DELETE_fwkStatementLog]". [SQLSTATE 01000]
DBCC results for 'rptCSFSummaryMetaData'. [SQLSTATE 01000]
There are 5 rows in 1 pages for object "rptCSFSummaryMetaData". [SQLSTATE 01000]
DBCC results for 'vndBusinessEntityType'. [SQLSTATE 01000]
There are 13 rows in 1 pages for object "vndBusinessEntityType". [SQLSTATE 01000]
DBCC results for '[!DELETE_fwkStatementLogDetail]'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "[!DELETE_fwkStatementLogDetail]". [SQLSTATE 01000]
DBCC results for 'rptCSFSummary'. [SQLSTATE 01000]
There are 16450 rows in 370 pages for object "rptCSFSummary". [SQLSTATE 01000]
DBCC results for 'fwkCSFUsage'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object "fwkCSFUsage". [SQLSTATE 01000]
DBCC results for 'fwkMessageLogRecipient'. [SQLSTATE 01000]
There are 532188 rows in 3686 pages for object "fwkMessageLogRecipient". [SQLSTATE 01000]
DBCC results for 'vndSkillProfile'. [SQLSTATE 01000]
There are 1659 rows in 11 pages for object "vndSkillProfile". [SQLSTATE 01000]
DBCC results for 'rteRateCardStatus'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object "rteRateCardStatus". [SQLSTATE 01000]
DBCC results for 'rptParameter'. [SQLSTATE 01000]
There are 89 rows in 2 pages for object "rptParameter". [SQLSTATE 01000]
DBCC results for 'fwkGroup'. [SQLSTATE 01000]
There are 126645 rows in 1864 pages for object "fwkGroup". [SQLSTATE 01000]
DBCC results for 'vw_fwkCSFMatrixSimple'. [SQLSTATE 01000]
There are 164700 rows in 1461 pages for object "vw_fwkCSFMatrixSimple". [SQLSTATE 01000]
DBCC results for 'prcRequestVendorPost'. [SQLSTATE 01000]
There are 49909 rows in 397 pages for object "prcRequestVendorPost". [SQLSTATE 01000]
DBCC results for 'rteRateCard'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object "rteRateCard". [SQLSTATE 01000]
DBCC results for 'fwkUserPasswordHistory'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "fwkUserPasswordHistory". [SQLSTATE 01000]
DBCC results for 'prcResponseItemXFileUpload'. [SQLSTATE 01000]
There are 70 rows in 1 pages for object "prcResponseItemXFileUpload". [SQLSTATE 01000]
DBCC results for 'fwkUserNotRecommendForReuse'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object "fwkUserNotRecommendForReuse". [SQLSTATE 01000]
DBCC results for 'vw_fwkCSFMatrixSimple_Extension'. [SQLSTATE 01000]
There are 29 rows in 1 pages for object "vw_fwkCSFMatrixSimple_Extension". [SQLSTATE 01000]
DBCC results for 'schScheduledTaskStatus'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object "schScheduledTaskStatus". [SQLSTATE 01000]
DBCC results for 'prcCustomRequestTemplateState'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object "prcCustomRequestTemplateState". [SQLSTATE 01000]
DBCC results for 'prcRequisitionCSFKey'. [SQLSTATE 01000]
There are 36326 rows in 206 pages for object "prcRequisitionCSFKey". [SQLSTATE 01000]
DBCC results for 'Billing.accInvoiceGroupableField'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Billing.accInvoiceGroupableField". [SQLSTATE 01000]
DBCC results for 'prcDeliverable'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "prcDeliverable". [SQLSTATE 01000]
DBCC results for 'mtaViewColumns'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "mtaViewColumns". [SQLSTATE 01000]
DBCC results for 'impUploadFallout'. [SQLSTATE 01000]
There are 16 rows in 1 pages for object "impUploadFallout". [SQLSTATE 01000]
DBCC results for 'rptTimecardCSFs'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "rptTimecardCSFs". [SQLSTATE 01000]
DBCC results for 'prcEnumeration'. [SQLSTATE 01000]
There are 393533 rows in 4817 pages for object "prcEnumeration". [SQLSTATE 01000]
DBCC results for 'Reports.Version'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object "Reports.Version". [SQLSTATE 01000]
DBCC results for 'ActiveObject.EntityOrphaned'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "ActiveObject.EntityOrphaned". [SQLSTATE 01000]
DBCC results for 'prcWorkFlowType'. [SQLSTATE 01000]
There are 5 rows in 1 pages for object "prcWorkFlowType". [SQLSTATE 01000]
DBCC results for 'fwkUserXGroup'. [SQLSTATE 01000]
There are 192384 rows in 821 pages for object "fwkUserXGroup". [SQLSTATE 01000]
DBCC results for 'vndVendor'. [SQLSTATE 01000]
There are 130 rows in 2 pages for object "vndVendor". [SQLSTATE 01000]
DBCC results for 'fwkUserAuthenticationLogArchive'. [SQLSTATE 01000]
There are 57461764 rows in 897974 pages for object "fwkUserAuthenticationLogArchive". [SQLSTATE 01000]
DBCC results for 'fwkMessageTemplate'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "fwkMessageTemplate". [SQLSTATE 01000]
DBCC results for 'fwkOrg'. [SQLSTATE 01000]
There are 138 rows in 2 pages for object "fwkOrg". [SQLSTATE 01000]
DBCC results for 'prcTemplateSearchType'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object "prcTemplateSearchType". [SQLSTATE 01000]
DBCC results for 'prcHumanResourceActivity'. [SQLSTATE 01000]
There are 19122 rows in 296 pages for object "prcHumanResourceActivity". [SQLSTATE 01000]
CHECKDB found 0 allocation errors and 0 consistency errors in database 'Consol_raytheon'. [SQLSTATE 01000]
DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]
DBCC results for 'SupplierWebsitePS'. [SQLSTATE 01000]
Service Broker Msg 9675, State 1: Message Types analyzed: 14. [SQLSTATE 01000]
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. [SQLSTATE 01000]
Service Broker Msg 9667, State 1: Services analyzed: 3. [SQLSTATE 01000]
Service Broker Msg 9668, State 1: Service Queues analyzed: 3. [SQLSTATE 01000]
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. [SQLSTATE 01000]
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. [SQLSTATE 01000]
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. [SQLSTATE 01000]
DBCC results for 'sys.sysrowsetcolumns'. [SQLSTATE 01000]
There are 1080 rows in 8 pages for object "sys.sysrowsetcolumns". [SQLSTATE 01000]
DBCC results for 'sys.sysrowsets'. [SQLSTATE 01000]
There are 210 rows in 2 pages for object "sys.sysrowsets". [SQLSTATE 01000]
DBCC results for 'sysallocunits'. [SQLSTATE 01000]
There are 226 rows in 3 pages for object "sysallocunits". [SQLSTATE 01000]
DBCC results for 'sys.sysfiles1'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object "sys.sysfiles1". [SQLSTATE 01000]
DBCC results for 'sys.syshobtcolumns'. [SQLSTATE 01000]
There are 1080 rows in 9 pages for object "sys.syshobtcolumns". [SQLSTATE 01000]
DBCC results for 'sys.syshobts'. [SQLSTATE 01000]
There are 210 rows in 2 pages for object "sys.syshobts". [SQLSTATE 01000]
DBCC results for 'sys.sysftinds'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysftinds". [SQLSTATE 01000]
DBCC results for 'sys.sysserefs'. [SQLSTATE 01000]
There are 226 rows in 1 pages for object "sys.sysserefs". [SQLSTATE 01000]
DBCC results for 'sys.sysowners'. [SQLSTATE 01000]
There are 17 rows in 1 pages for object "sys.sysowners". [SQLSTATE 01000]
DBCC results for 'sys.sysprivs'. [SQLSTATE 01000]
There are 123 rows in 1 pages for object "sys.sysprivs". [SQLSTATE 01000]
DBCC results for 'sys.sysschobjs'. [SQLSTATE 01000]
There are 395 rows in 7 pages for object "sys.sysschobjs". [SQLSTATE 01000]
DBCC results for 'sys.syscolpars'. [SQLSTATE 01000]
There are 1485 rows in 29 pages for object "sys.syscolpars". [SQLSTATE 01000]
DBCC results for 'sys.sysnsobjs'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object "sys.sysnsobjs". [SQLSTATE 01000]
DBCC results for 'sys.syscerts'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.syscerts". [SQLSTATE 01000]
DBCC results for 'sys.sysxprops'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysxprops". [SQLSTATE 01000]
DBCC results for 'sys.sysscalartypes'. [SQLSTATE 01000]
There are 27 rows in 1 pages for object "sys.sysscalartypes". [SQLSTATE 01000]
DBCC results for 'sys.systypedsubobjs'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.systypedsubobjs". [SQLSTATE 01000]
DBCC results for 'sys.sysidxstats'. [SQLSTATE 01000]
There are 274 rows in 6 pages for object "sys.sysidxstats". [SQLSTATE 01000]
DBCC results for 'sys.sysiscols'. [SQLSTATE 01000]
There are 454 rows in 2 pages for object "sys.sysiscols". [SQLSTATE 01000]
DBCC results for 'sys.sysbinobjs'. [SQLSTATE 01000]
There are 23 rows in 1 pages for object "sys.sysbinobjs". [SQLSTATE 01000]
DBCC results for 'sys.sysobjvalues'. [SQLSTATE 01000]
There are 471 rows in 100 pages for object "sys.sysobjvalues". [SQLSTATE 01000]
DBCC results for 'sys.sysclsobjs'. [SQLSTATE 01000]
There are 22 rows in 1 pages for object "sys.sysclsobjs". [SQLSTATE 01000]
DBCC results for 'sys.sysrowsetrefs'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysrowsetrefs". [SQLSTATE 01000]
DBCC results for 'sys.sysremsvcbinds'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysremsvcbinds". [SQLSTATE 01000]
DBCC results for 'sys.sysxmitqueue'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysxmitqueue". [SQLSTATE 01000]
DBCC results for 'sys.sysrts'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object "sys.sysrts". [SQLSTATE 01000]
DBCC results for 'sys.sysconvgroup'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysconvgroup". [SQLSTATE 01000]
DBCC results for 'sys.sysdesend'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysdesend". [SQLSTATE 01000]
DBCC results for 'sys.sysdercv'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysdercv". [SQLSTATE 01000]
DBCC results for 'sys.syssingleobjrefs'. [SQLSTATE 01000]
There are 201 rows in 1 pages for object "sys.syssingleobjrefs". [SQLSTATE 01000]
DBCC results for 'sys.sysmultiobjrefs'. [SQLSTATE 01000]
There are 1246 rows in 9 pages for object "sys.sysmultiobjrefs". [SQLSTATE 01000]
DBCC results for 'sys.sysdbfiles'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object "sys.sysdbfiles". [SQLSTATE 01000]
DBCC results for 'sys.sysguidrefs'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysguidrefs". [SQLSTATE 01000]
DBCC results for 'sys.sysqnames'. [SQLSTATE 01000]
There are 91 rows in 1 pages for object "sys.sysqnames". [SQLSTATE 01000]
DBCC results for 'sys.sysxmlcomponent'. [SQLSTATE 01000]
There are 93 rows in 1 pages for object "sys.sysxmlcomponent". [SQLSTATE 01000]
DBCC results for 'sys.sysxmlfacet'. [SQLSTATE 01000]
There are 97 rows in 1 pages for object "sys.sysxmlfacet". [SQLSTATE 01000]
DBCC results for 'sys.sysxmlplacement'. [SQLSTATE 01000]
There are 17 rows in 1 pages for object "sys.sysxmlplacement". [SQLSTATE 01000]
DBCC results for 'sys.sysobjkeycrypts'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts". [SQLSTATE 01000]
DBCC results for 'sys.sysasymkeys'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysasymkeys". [SQLSTATE 01000]
DBCC results for 'sys.syssqlguides'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.syssqlguides". [SQLSTATE 01000]
DBCC results for 'sys.sysbinsubobjs'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysbinsubobjs". [SQLSTATE 01000]
DBCC results for 'Security.CustomerGroup'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.CustomerGroup". [SQLSTATE 01000]
DBCC results for 'Framework.NotificationType'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object "Framework.NotificationType". [SQLSTATE 01000]
DBCC results for 'Security.UserAuthentication'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.UserAuthentication". [SQLSTATE 01000]
DBCC results for 'Security.CustomerGroupHistorical'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.CustomerGroupHistorical". [SQLSTATE 01000]
DBCC results for 'Security.CustomerHistorical'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.CustomerHistorical". [SQLSTATE 01000]
DBCC results for 'Security.Role'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object "Security.Role". [SQLSTATE 01000]
DBCC results for 'Security.User'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object "Security.User". [SQLSTATE 01000]
DBCC results for 'Security.UserAuthenticationEvent'. [SQLSTATE 01000]
There are 9 rows in 1 pages for object "Security.UserAuthenticationEvent". [SQLSTATE 01000]
DBCC results for 'Security.UserBlockedHistorical'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.UserBlockedHistorical". [SQLSTATE 01000]
DBCC results for 'Security.UserBlockEvent'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object "Security.UserBlockEvent". [SQLSTATE 01000]
DBCC results for 'Security.vwUserXCustomerDimension_VendorAdmin'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.vwUserXCustomerDimension_VendorAdmin". [SQLSTATE 01000]
DBCC results for 'Track.ETLMaster'. [SQLSTATE 01000]
There are 7 rows in 1 pages for object "Track.ETLMaster". [SQLSTATE 01000]
DBCC results for 'Security.vwUserXCustomerDimension_VendorUser'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.vwUserXCustomerDimension_VendorUser". [SQLSTATE 01000]
DBCC results for 'Security.vwUserXSupplierDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.vwUserXSupplierDimension". [SQLSTATE 01000]
DBCC results for 'Security.UserBlockHistorical'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.UserBlockHistorical". [SQLSTATE 01000]
DBCC results for 'Track.ETLProcessStatus'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object "Track.ETLProcessStatus". [SQLSTATE 01000]
DBCC results for 'Track.ETLProcessTransaction'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Track.ETLProcessTransaction". [SQLSTATE 01000]
DBCC results for 'Security.UserHistorical'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object "Security.UserHistorical". [SQLSTATE 01000]
DBCC results for 'Security.UserIsActive'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object "Security.UserIsActive". [SQLSTATE 01000]
DBCC results for 'Track.ETLStoredProcedure'. [SQLSTATE 01000]
There are 7 rows in 1 pages for object "Track.ETLStoredProcedure". [SQLSTATE 01000]
DBCC results for 'Security.UserPasswordEvent'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object "Security.UserPasswordEvent". [SQLSTATE 01000]
DBCC results for 'Security.UserPasswordHistorical'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object "Security.UserPasswordHistorical". [SQLSTATE 01000]
DBCC results for 'Track.ProcessEvent'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object "Track.ProcessEvent". [SQLSTATE 01000]
DBCC results for 'Track.ProcessTrack'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Track.ProcessTrack". [SQLSTATE 01000]
DBCC results for 'Security.UserStatus'. [SQLSTATE 01000]
There are 5 rows in 1 pages for object "Security.UserStatus". [SQLSTATE 01000]
DBCC results for 'Security.UserStatusHistorical'. [SQLSTATE 01000]
There are 6 rows in 1 pages for object "Security.UserStatusHistorical". [SQLSTATE 01000]
DBCC results for 'Security.UserXCustomerGroup'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.UserXCustomerGroup". [SQLSTATE 01000]
DBCC results for 'Security.UserXCustomerGroupHistorical'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.UserXCustomerGroupHistorical". [SQLSTATE 01000]
DBCC results for 'Security.UserXManagerHistorical'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.UserXManagerHistorical". [SQLSTATE 01000]
DBCC results for 'Security.UserXRole'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object "Security.UserXRole". [SQLSTATE 01000]
DBCC results for 'Security.UserXRoleHistorical'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object "Security.UserXRoleHistorical". [SQLSTATE 01000]
DBCC results for 'Hold.HoldCheckDateDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Hold.HoldCheckDateDimension". [SQLSTATE 01000]
DBCC results for 'Security.UserXVendorGroup'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.UserXVendorGroup". [SQLSTATE 01000]
DBCC results for 'Hold.HoldContractorDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Hold.HoldContractorDimension". [SQLSTATE 01000]
DBCC results for 'Hold.HoldCustomerDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Hold.HoldCustomerDimension". [SQLSTATE 01000]
DBCC results for 'Security.UserXVendorGroupHistorical'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.UserXVendorGroupHistorical". [SQLSTATE 01000]
DBCC results for 'Hold.HoldExpenseFact'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Hold.HoldExpenseFact". [SQLSTATE 01000]
DBCC results for 'Security.Vendor'. [SQLSTATE 01000]
There are 1912 rows in 18 pages for object "Security.Vendor". [SQLSTATE 01000]
DBCC results for 'Hold.HoldPaymentDueDateDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Hold.HoldPaymentDueDateDimension". [SQLSTATE 01000]
DBCC results for 'Hold.HoldPaymentFact'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Hold.HoldPaymentFact". [SQLSTATE 01000]
DBCC results for 'Security.VendorGroup'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.VendorGroup". [SQLSTATE 01000]
DBCC results for 'Hold.HoldSupplierDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Hold.HoldSupplierDimension". [SQLSTATE 01000]
DBCC results for 'Security.VendorGroupHistorical'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.VendorGroupHistorical". [SQLSTATE 01000]
DBCC results for 'Hold.HoldVoucherDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Hold.HoldVoucherDimension". [SQLSTATE 01000]
DBCC results for 'Security.VendorGroupXCustomerGroup'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.VendorGroupXCustomerGroup". [SQLSTATE 01000]
DBCC results for 'Hold.HoldVoucherFact'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Hold.HoldVoucherFact". [SQLSTATE 01000]
DBCC results for 'Hold.HoldWeekendingDateDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Hold.HoldWeekendingDateDimension". [SQLSTATE 01000]
DBCC results for 'Security.VendorGroupXCustomerGroupHistorical'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.VendorGroupXCustomerGroupHistorical". [SQLSTATE 01000]
DBCC results for 'Publish.CheckDateDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.CheckDateDimension". [SQLSTATE 01000]
DBCC results for 'Security.VendorHistorical'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Security.VendorHistorical". [SQLSTATE 01000]
DBCC results for 'Publish.ContractorDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.ContractorDimension". [SQLSTATE 01000]
DBCC results for 'Publish.CustomerDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.CustomerDimension". [SQLSTATE 01000]
DBCC results for 'Publish.DateLoaded'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.DateLoaded". [SQLSTATE 01000]
DBCC results for 'Publish.ExpenseFact'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.ExpenseFact". [SQLSTATE 01000]
DBCC results for 'Publish.PaymentDueDateDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.PaymentDueDateDimension". [SQLSTATE 01000]
DBCC results for 'Publish.PaymentFact'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.PaymentFact". [SQLSTATE 01000]
DBCC results for 'Publish.Report'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object "Publish.Report". [SQLSTATE 01000]
DBCC results for 'Publish.SupplierDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.SupplierDimension". [SQLSTATE 01000]
DBCC results for 'Publish.VoucherDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.VoucherDimension". [SQLSTATE 01000]
DBCC results for 'Publish.VoucherFact'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.VoucherFact". [SQLSTATE 01000]
DBCC results for 'Publish.WeekendingDateDimension'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Publish.WeekendingDateDimension". [SQLSTATE 01000]
DBCC results for 'Framework.ErrorEvent'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Framework.ErrorEvent". [SQLSTATE 01000]
DBCC results for 'Framework.Version'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Framework.Version". [SQLSTATE 01000]
DBCC results for 'Framework.ErrorEventType'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object "Framework.ErrorEventType". [SQLSTATE 01000]
DBCC results for 'sys.queue_messages_1977058079'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079". [SQLSTATE 01000]
DBCC results for 'sys.queue_messages_2009058193'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193". [SQLSTATE 01000]
DBCC results for 'Framework.ErrorLog'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Framework.ErrorLog". [SQLSTATE 01000]
DBCC results for 'sys.queue_messages_2041058307'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307". [SQLSTATE 01000]
DBCC results for 'Security.Customer'. [SQLSTATE 01000]
There are 221 rows in 3 pages for object "Security.Customer". [SQLSTATE 01000]
DBCC results for 'Framework.Notification'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "Framework.Notification". [SQLSTATE 01000]
DBCC results for 'Framework.NotificationStatus'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object "Framework.NotificationStatus". [SQLSTATE 01000]
CHECKDB found 0 allocation errors and 0 consistency errors in database 'SupplierWebsitePS'. [SQLSTATE 01000]
DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2010-03-29 : 16:01:23
But did the job fail when you got this output? It looks like a successful run to me.

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

Subscribe to my blog
Go to Top of Page

DBA007
Posting Yak Master

145 Posts
Posted - 2010-03-29 : 16:22:51
yes the job had failed.
Go to Top of Page

DBA007
Posting Yak Master

145 Posts
Posted - 2010-03-29 : 16:25:19
the output which i have pasted is not the compleate one as hear the space is not enough to paste entire, you can check over the link below for the complete output attached as a file
http://www.sqlservercentral.com/Forums/Topic890927-146-2.aspx
Go to Top of Page

DBA007
Posting Yak Master

145 Posts
Posted - 2010-04-07 : 09:12:39
Team,any update on this...
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site