How to set SET IMPLICIT_TRANSACTIONS and other ANSI options?

Toad for SQL Server
1

HI guys,

I cannot seem to find where in TOAD for SQL Server (6.1) I can set ANSI default options, like you can with SQL Server Management Studio.

tmp1.jpeg

2

Hi,

Please try to go Tool->Administrator->Server properties->Connections Tab and In Default User Options, change the setting,

Is this what you want?

Thanks,

Cathy.

3

Hmmm looks like it, but which option is explicitely the one I mentioned above - SET IMPLICIT_TRANSACTIONS?

4

Here for you.

5

???

6

Hi,

Like Cathy screen attachment, SET IMPLICIT_TRANSACTIONS also in below path:

Tool->Administrator->Server properties->Connections Tab

Thanks,

Kelly

7

Got you! Thanks