How to set QuotedIdentifier property off or on for existing table

Hi All,
How to set QuotedIdentifier property off or on for existing table. I tried
like
SET QuotedIdentifier off.
But the property is not chnaging.
Any idea?
Thanks in advance.
Supriya.Hi
This property is set when you create the table e.g
USE TEMPDB
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE TABLE tablquoteoff ( id int not null )
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE tablquoteon ( id int not null )
GO
SELECT
OBJECTPROPERTY(OBJECT_ID('tablquoteoff'),'IsQuotedIdentOn'),
OBJECTPROPERTY(OBJECT_ID('tablquoteon'),'IsQuotedIdentOn')
John
"Supriya Pagadala" wrote:
> Hi All,
> How to set QuotedIdentifier property off or on for existing table. I tried
> like
> SET QuotedIdentifier off.
> But the property is not chnaging.
> Any idea?
> Thanks in advance.
> Supriya.
>
>|||Thank for response.
I tried this.
SET QUOTED_IDENTIFIER OFF
GO
CREATE TABLE tablquoteoff ( id int not null )
But QUOTED_IDENTIFIER property of table is always true.
Not getting why it is not updating.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:03B62E37-AB8B-4D00-B9BE-4B7355112689@.microsoft.com...
> Hi
> This property is set when you create the table e.g
> USE TEMPDB
> GO
> SET QUOTED_IDENTIFIER OFF
> GO
> CREATE TABLE tablquoteoff ( id int not null )
> GO
> SET QUOTED_IDENTIFIER ON
> GO
> CREATE TABLE tablquoteon ( id int not null )
> GO
> SELECT
> OBJECTPROPERTY(OBJECT_ID('tablquoteoff'),'IsQuotedIdentOn'),
> OBJECTPROPERTY(OBJECT_ID('tablquoteon'),'IsQuotedIdentOn')
>
> John
> "Supriya Pagadala" wrote:
>> Hi All,
>> How to set QuotedIdentifier property off or on for existing table. I
>> tried
>> like
>> SET QuotedIdentifier off.
>> But the property is not chnaging.
>> Any idea?
>> Thanks in advance.
>> Supriya.
>>|||Hello, Supriya
The IsQuotedIdentOn property is only meaningful for stored procedures,
triggers, views and UDF-s. For other types of objects (tables,
constraints, etc) it is always 1.
Razvan|||Hi
The script was to show that the value is taken when the table was created
and will not change with your connection setting. To change this setting I
believe you would need to create a new table and transfer the data.
John
"Supriya Pagadala" wrote:
> Thank for response.
> I tried this.
> SET QUOTED_IDENTIFIER OFF
> GO
> CREATE TABLE tablquoteoff ( id int not null )
> But QUOTED_IDENTIFIER property of table is always true.
> Not getting why it is not updating.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:03B62E37-AB8B-4D00-B9BE-4B7355112689@.microsoft.com...
> > Hi
> >
> > This property is set when you create the table e.g
> >
> > USE TEMPDB
> > GO
> >
> > SET QUOTED_IDENTIFIER OFF
> > GO
> >
> > CREATE TABLE tablquoteoff ( id int not null )
> > GO
> >
> > SET QUOTED_IDENTIFIER ON
> > GO
> >
> > CREATE TABLE tablquoteon ( id int not null )
> > GO
> >
> > SELECT
> > OBJECTPROPERTY(OBJECT_ID('tablquoteoff'),'IsQuotedIdentOn'),
> > OBJECTPROPERTY(OBJECT_ID('tablquoteon'),'IsQuotedIdentOn')
> >
> >
> > John
> >
> > "Supriya Pagadala" wrote:
> >
> >> Hi All,
> >>
> >> How to set QuotedIdentifier property off or on for existing table. I
> >> tried
> >> like
> >>
> >> SET QuotedIdentifier off.
> >>
> >> But the property is not chnaging.
> >>
> >> Any idea?
> >>
> >> Thanks in advance.
> >>
> >> Supriya.
> >>
> >>
> >>
>
>