Optimization Job fails

Hi everyone,
We have more than 100 databases on one SQL Server instance and all databases
are backed up and optimised in the nightly maintenance plan.
I copied a new database in this instance that has some computed columns in
few tables. Now, I'm getting this error in daily maintenance plan's
optimization job that it failed because "Quoted_Identifier" is OFF.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]UPDATE STATISTICS failed because the following
SET
options have incorrect settings: 'QUOTED_IDENTIFIER'.
Any idea/help to overcome this situation. I have some other databases with
computed columns and have same set of database options. There is no problem
with those databases. Only one database is causing this. Any idea ?
Thanks in advance.Sqlmaint.exe does not set quoted_identified on by default. You should create
a T-SQL job which sets this option. See
http://support.microsoft.com/defaul...kb;en-us;301292 for a similar
problem.
Adrian
"Ahmed" <Ahmed@.discussions.microsoft.com> wrote in message
news:1E48F884-3DBD-465E-BDB9-0D0B110BA832@.microsoft.com...
> Hi everyone,
> We have more than 100 databases on one SQL Server instance and all
> databases
> are backed up and optimised in the nightly maintenance plan.
> I copied a new database in this instance that has some computed columns in
> few tables. Now, I'm getting this error in daily maintenance plan's
> optimization job that it failed because "Quoted_Identifier" is OFF.
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
[ODBC
> SQL
> Server Driver][SQL Server]UPDATE STATISTICS failed because the followi
ng
> SET
> options have incorrect settings: 'QUOTED_IDENTIFIER'.
> Any idea/help to overcome this situation. I have some other databases with
> computed columns and have same set of database options. There is no
> problem
> with those databases. Only one database is causing this. Any idea ?
> Thanks in advance.
>