Simon Oliver writes:
> With Synase ASA you can use "SELECT CONNECTION_PROPERTY ('QUOTED_IDENTIFIER')"
> to determine the current state. I've tried but failed to determine the
> current state with MS-SQL server using sp_dboption and sp_configure 'user
> options' - perhaps Michael Peppler knows how to do this?
You can do it via the OpenClient API.
And there is the @@options variable that is a bit map of current
connection options set via the SET command:
[21] SYBASE.master: 1> select @@options
[21] SYBASE.master: 2> go
--------------------
0x80210000000f0100
(1 row affected)
[22] SYBASE.master: 1> set quoted_identifier on
[22] SYBASE.master: 2> go
[23] SYBASE.master: 1> select @@options
[23] SYBASE.master: 2> go
--------------------
0x80210001000f0100
(1 row affected)
[24] SYBASE.master: 1>
Michael
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
[EMAIL PROTECTED] - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
