set quoted_identifiers on

[Database Administrator]

Hello, is there a way to have quoted_identifiers on as a default for
connections?

[Database Administrator]

"Daoud" wrote in message
news:9a9b20c7-46d6-4f65-a90d-178244140dc1@r36g2000vbn.googlegroups.com...
> Hello, is there a way to have quoted_identifiers on as a default for
> connections?


Create a login trigger, and put ' set quoted_identifier on' in it. This will
enable quoted id's for the session. In 12.5.4 or 15.0.2, you can use a
global login trigger that does this for all logins; in 12.5.0 - 12.5.3
you'll need to use a login-specific login trigger for each login where you
want to enable this for.
See http://www.sypron.nl/logtrig for more info.

HTH,
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------