Quoted identifier

On the Options tab in database properties, there is an option of Use quoted
identifiers,
does anyone knows the option of this for what purpose and any example ?
Connection settings, such as quoted identifiers, can be set at the
connection, database or server level:
1) connection: SET QUOTED_IDENTIFIER ON
2) database: Enterprise Manager database properties or
ALTER DATABASE MyDatabase
SET QUOTED_IDENTIFIER ON
3) server: EXEC sp_configure 'user options', 256
Settings at the connection level override database and server settings.
Setting at the database level override the server specification.
When quoted identifiers is on (the ANSI standard), double quotes can be used
to enclose identifiers and single quotes are used for literal strings. OLE
DB and ODBC APIs set QUOTED_IDENTIFIER ON when connecting.
See the Books Online for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:usKgtRpqEHA.3980@.TK2MSFTNGP12.phx.gbl...
> On the Options tab in database properties, there is an option of Use
> quoted
> identifiers,
> does anyone knows the option of this for what purpose and any example ?
>

Quoted identifier

On the Options tab in database properties, there is an option of Use quoted
identifiers,
does anyone knows the option of this for what purpose and any example ?Connection settings, such as quoted identifiers, can be set at the
connection, database or server level:
1) connection: SET QUOTED_IDENTIFIER ON
2) database: Enterprise Manager database properties or
ALTER DATABASE MyDatabase
SET QUOTED_IDENTIFIER ON
3) server: EXEC sp_configure 'user options', 256
Settings at the connection level override database and server settings.
Setting at the database level override the server specification.
When quoted identifiers is on (the ANSI standard), double quotes can be used
to enclose identifiers and single quotes are used for literal strings. OLE
DB and ODBC APIs set QUOTED_IDENTIFIER ON when connecting.
See the Books Online for details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:usKgtRpqEHA.3980@.TK2MSFTNGP12.phx.gbl...
> On the Options tab in database properties, there is an option of Use
> quoted
> identifiers,
> does anyone knows the option of this for what purpose and any example ?
>

QueueSizeMultiplier - Merge Agent Profile Parameter SQL 2005

I see a parameter in the "high volume server-to-server" merge agent profile
named QueueSizeMultiplier.
Can anyone tell me...
The purpose of this paramter
The possible values and their meaning.
Its seems to be undocumented. Default is null, maximum listed seems to be 5.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Pat Clough" <Pat Clough@.discussions.microsoft.com> wrote in message
news:B4E5DBAB-9734-4AC2-BCA3-E85F512F22F0@.microsoft.com...
>I see a parameter in the "high volume server-to-server" merge agent profile
> named QueueSizeMultiplier.
> Can anyone tell me...
> The purpose of this paramter
> The possible values and their meaning.