dbTalk Databases Forums  

set quoted_identifiers on

comp.databases.sybase comp.databases.sybase


Discuss set quoted_identifiers on in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Daoud
 
Posts: n/a

Default set quoted_identifiers on - 08-24-2009 , 11:54 AM






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

Reply With Quote
  #2  
Old   
Rob V
 
Posts: n/a

Default Re: set quoted_identifiers on - 09-02-2009 , 10:19 AM






"Daoud" <ustadbaba (AT) gmail (DOT) com> wrote

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) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.