Microsoft Dynamics CRM (Archived)

After upgrade to CRM 2011: SQL error 'QUOTED_IDENTIFIER'

(0) Share

Report

Posted on by lana feldman

2,045

Hi All.

After the upgrade to CRM 2011 + Rollup6 we get SQL error when qualifying a Lead:

"UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations."

Thanks a lot!

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Gus Gonzalez 27,113 on at

Like (0)

Report

Hello,

Is it possible that this issue is related to this article?

www.sqlservercentral.com/.../Topic473503-146-2.aspx

Was this reply helpful? Yes No
lana feldman 2,045 on at

Like (0)

Report

I realize that somewhere 'QUOTED_IDENTIFIER' option is not what expected by the Update statement.

But on what table? Looks like my old CRM 4 server has this option "False" on the Server level and all the tables, but CRM 2011 switched them all to True.

Any thoughts?

Thank you.

Was this reply helpful? Yes No
Gus Gonzalez 27,113 on at

Like (0)

Report

I am not sure here...We have CRM 2011 Online...do you have the posibility of opening a support ticket with Microsoft?

Was this reply helpful? Yes No
lana feldman 2,045 on at

Like (0)

Report

I guess I'll open a ticket with MS.

Was this reply helpful? Yes No
Verified answer

lana feldman 2,045 on at

Like (0)

Report

Oh, figured it out.

The offender was a custom trigger. I dropped it and the problem is gone.

Thanks again for trying to help!

Was this reply helpful? Yes No
Gus Gonzalez 27,113 on at

Like (0)

Report

No problem, I am glad you resolved it.

Was this reply helpful? Yes No
Mohammad Atif on at

Like (0)

Report

In CRM 4.0 by default, It is set to FALSE in the ORG_MSCRM database settings but in CRM 2011 this is by default TRUE.

Thanks,

Mohammad

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello!! I would like to know how can I change this setting on the ORD_MSCRM. Great post!! Thanks! Pablo

Was this reply helpful? Yes No