Toad World® Forums

How to set SET IMPLICIT_TRANSACTIONS and other ANSI options?


#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