InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 07:58:46 GMT20http://www.sqlservercentral.com/Forums/Topic875988-146-1.aspxYou need to run the following on that database and post the results here:DBCC CHECKDB({your database}) WITH all_errormsgs, no_infomsgs;What you posted before does not show the errors and we need to see all of the errors to determine what needs to be done. I would start by identifying a clean backup and start getting prepared to restore from that backup. In most cases, the easiest and best way to recover from an integrity problem is to restore.Wed, 03 Mar 2010 09:39:31 GMTJeffrey Williams 3188http://www.sqlservercentral.com/Forums/Topic875988-146-1.aspxTeam,My databaseIntegrity job has failed stating the error as follows,iam using the script to do thisService 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.Wed, 03 Mar 2010 07:58:41 GMTdba_neo