| Computers Forum Index » Computer - Databases - Sybase » set quoted_identifiers on... |
|
Page 1 of 1 |
|
| Author |
Message |
| Daoud... |
 Posted: Mon Aug 24, 2009 4:54 pm |
|
|
|
Guest
|
Hello, is there a way to have quoted_identifiers on as a default for
connections? |
|
|
| Back to top |
|
|
|
| Rob V... |
| Posted: Wed Sep 02, 2009 7:19 pm |
|
|
|
Guest
|
"Daoud" <ustadbaba at (no spam) gmail.com> wrote in message
news:9a9b20c7-46d6-4f65-a90d-178244140dc1 at (no spam) r36g2000vbn.googlegroups.com...
Quote: 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 at (no spam) YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
----------------------------------------------------------------- |
|
|
| Back to top |
|
|
|
|
