quoted_identifier

How do I see the current value of QUOTED_IDENTIFIER in a SQL2000
database? Thank you.Select OBJECTPROPERTY(DB_ID(),'IsQuotedIdentOn'
)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Rick Charnes" <rickxyz--nospam.zyxcharnes@.thehartford.com> schrieb im
Newsbeitrag news:MPG.1cd87166eb1a31ef9898d6@.msnews.microsoft.com...
> How do I see the current value of QUOTED_IDENTIFIER in a SQL2000
> database? Thank you.|||You can determine the database default QUOTED_IDENTIFIER setting is on with
DATABASEPROPERTY. However, connection settings take precedence and
QUOTED_IDENTIFIER ON is the default OLEDB and ODBC connection setting.
SELECT DATABASEPROPERTY('MyDatabase', 'IsQuotedIdentifiersEnabled')
Hope this helps.
Dan Guzman
SQL Server MVP
"Rick Charnes" <rickxyz--nospam.zyxcharnes@.thehartford.com> wrote in message
news:MPG.1cd87166eb1a31ef9898d6@.msnews.microsoft.com...
> How do I see the current value of QUOTED_IDENTIFIER in a SQL2000
> database? Thank you.|||In article <uIVaoSsSFHA.2128@.TK2MSFTNGP14.phx.gbl>, guzmanda@.nospam-
online.sbcglobal.net says...
> You can determine the database default QUOTED_IDENTIFIER setting is on wit
h
> DATABASEPROPERTY. However, connection settings take precedence and
> QUOTED_IDENTIFIER ON is the default OLEDB and ODBC connection setting.
> SELECT DATABASEPROPERTY('MyDatabase', 'IsQuotedIdentifiersEnabled')
>
Thanks. The above SELECT statement returns 0 on my database which I
assume indicates that quoted_identifier is OFF. But can you explain
what you mean when you say 'connection settings take precedence'? Are
'connection settings' something different from the DATABASE setting
returned by this SELECT statement? I am accessing SQLServer through my
application using OLEDB. Thanks much for your help.|||Check out the SET command. For some database options, you have the same beha
vior exposed through a
SET command. A setting though a SET command applies to a connection ("sessio
n"). Some API's will set
some SET commands for you. And I believe that both ODBC and OLEDB will set t
he quoted_identifier
setting, making the database option useless for those API's.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rick Charnes" <rickxyz--nospam.zyxcharnes@.thehartford.com> wrote in message
news:MPG.1cd9641ac7ff34569898d7@.msnews.microsoft.com...
> In article <uIVaoSsSFHA.2128@.TK2MSFTNGP14.phx.gbl>, guzmanda@.nospam-
> online.sbcglobal.net says...
> Thanks. The above SELECT statement returns 0 on my database which I
> assume indicates that quoted_identifier is OFF. But can you explain
> what you mean when you say 'connection settings take precedence'? Are
> 'connection settings' something different from the DATABASE setting
> returned by this SELECT statement? I am accessing SQLServer through my
> application using OLEDB. Thanks much for your help.|||Ah... So you're saying both a SET command *and* the API will set the
connection properties *for the session*, as opposed to the database
setting. And that even if the database setting for quoted_identifier is
OFF, the OLEDB interface sets it ON for any session in which it's used.
Is that right?
In article <OWknqczSFHA.2872@.TK2MSFTNGP14.phx.gbl>,
tibor_please.no.email_karaszi@.hotmail.nomail.com says...
> Check out the SET command. For some database options, you have the same be
havior exposed through a
> SET command. A setting though a SET command applies to a connection ("sess
ion"). Some API's will set
> some SET commands for you. And I believe that both ODBC and OLEDB will set
the quoted_identifier
> setting, making the database option useless for those API's.
>|||Yes, The API's actually executes a SET command for you (or at least to the s
ame effect).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rick Charnes" <rickxyz--nospam.zyxcharnes@.thehartford.com> wrote in message
news:MPG.1cd984b62c37b7169898d8@.msnews.microsoft.com...
> Ah... So you're saying both a SET command *and* the API will set the
> connection properties *for the session*, as opposed to the database
> setting. And that even if the database setting for quoted_identifier is
> OFF, the OLEDB interface sets it ON for any session in which it's used.
> Is that right?
> In article <OWknqczSFHA.2872@.TK2MSFTNGP14.phx.gbl>,
> tibor_please.no.email_karaszi@.hotmail.nomail.com says...