change default value XACT_ABORT at instacle level

Hi,

How can I changed default value for XACT_ABORT at instacle level?

Thanks.

Faheem Ansari

You may use sp_configure to set up. Follow these steps:

exec sp_configure 'show advanced options',1

go

RECONFIGURE'

gp

exec sp_configure 'user options',16384

go

RECONFIGURE

go

Note :

1. 16384 is the option ID for XACT_ABORT (0x4000)

2. You may have already configured some value using sp_configure before, then please make sure you are adding them up. For example, you already set the user option to be 1024 (ANSI_NULL_DFLT_ON), then you need to use

exec sp_configure 'user options',17408

Hope this helps.

Ping