Integrity Check Job Failure

Hi,
Psoted this is in Reporting Services, but no response:
I have the AdventureWorks2000 database (part of reporting services)
installed on a couple of servers. I have created a maintenance plan to run
the integrity check on all user servers. The job ran fine until the
AdventureWorks2000 db was installed. The jobs fails only on this db and works
just fine on other db's . Here is the
output from the maintenance plan:
Starting maintenance plan 'Master Server - All DB Integrity Check Job' on
4/10/2005 9:30:01 PM
[1] Database AdventureWorks2000: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL
Server Driver][SQL Server]DBCC failed because the following SET options have
incorrect settings: 'QUOTED_IDENTIFIER'.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the
following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
I tried setting different options, but nothing appears to solve the problem.
Any suggestions/ideas?
TIA,
DeeJay Puar
Look here, your problem is described there:
http://support.microsoft.com/kb/q301292/
HTH, Jens Smeyer.
http://www.sqlserver2005.de
"DeeJay Puar" <DeeJayPuar@.discussions.microsoft.com> schrieb im Newsbeitrag
news:197CD201-850D-447C-A461-C01EBD987657@.microsoft.com...
> Hi,
> Psoted this is in Reporting Services, but no response:
> I have the AdventureWorks2000 database (part of reporting services)
> installed on a couple of servers. I have created a maintenance plan to run
> the integrity check on all user servers. The job ran fine until the
> AdventureWorks2000 db was installed. The jobs fails only on this db and
> works
> just fine on other db's . Here is the
> output from the maintenance plan:
> Starting maintenance plan 'Master Server - All DB Integrity Check Job' on
> 4/10/2005 9:30:01 PM
> [1] Database AdventureWorks2000: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
> SQL
> Server Driver][SQL Server]DBCC failed because the following SET options
> have
> incorrect settings: 'QUOTED_IDENTIFIER'.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the
> following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
> I tried setting different options, but nothing appears to solve the
> problem.
> Any suggestions/ideas?
> TIA,
> DeeJay Puar
>
|||Hit the Nail on the Head...Thanks Jen.
I was only looking the Reporting Services Documentation.
DeeJay Puar
"Jens Sü?meyer" wrote:

> Look here, your problem is described there:
> http://support.microsoft.com/kb/q301292/
> HTH, Jens Sü?meyer.
> --
> http://www.sqlserver2005.de
> --
> "DeeJay Puar" <DeeJayPuar@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:197CD201-850D-447C-A461-C01EBD987657@.microsoft.com...
>
>