Getting this error while setting up the operator using DBArtisan tool.

Question

Getting this error while setting up the operator using DBArtisan tool.

SQL_Hunt

SSC-Dedicated

Points: 33518
More actions
March 3, 2015 at 9:14 am

#301625

[Microsoft][SQL Server Native Client 11.0][SQL Server]INSERT 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.(42000,1934) Procedure(trgDDLChangeLog)
Please suggest how to fix it.
Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 1

You should consult DBArtisan documentation and technical support because the software is trying to do something with an incorrect setting of QUOTED_IDENTIFIER.

As a workaround until you have this resolved, you can setup the operator using SQL Server Management Studio or with a T-SQL script.

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

Same error while I tried using SQL Management Studio too.

Thanks.

Lowell SSC Guru Points: 323518 More actions · Answer 3

i had a similar issue, which might help.

i wanted to start adding filtered indexes...indexes with WHERE statements; as soon as i added the first one, some processes started throwign that same error;

i used these two queries to find anything compiled or created witht he wrong set options.

then i scripted them out, and in a window witht he right options for quoted identifier and ansi nulls, and rebuilt them. after that, my filtered indexes worked without error. or side affecting other objects.

select * from (

select object_name(object_id) as ObjectName,

objectproperty(object_id,'ExecIsQuotedIdentOn') AS 'IsQuotedIdentifier',

objectproperty(object_id,'ExecIsAnsiNullsOn') as 'ISAnsiNulls'

from sys.procedures

) X WHERE IsQuotedIdentifier = 0

select * from (

select object_name(object_id) as ObjectName,

objectproperty(object_id,'ExecIsQuotedIdentOn') AS 'IsQuotedIdentifier',

objectproperty(object_id,'ExecIsAnsiNullsOn') as 'ISAnsiNulls'

from sys.objects

) X WHERE IsQuotedIdentifier = 0

select* from sys.indexes where name = 'IX_EDLogDetail_Filtered'

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!