I am using SQL server 2008. in my SPs, i often have to call for XML data type, functions (like split). Is it possible to permanently enable arithmentic abort for a database? I know it can be done using properties window > options but is there any script i can use to turn it on?
The reason to look for script is obvious; i have too many DBs to do it manually.
set arithabort off and
set arithabort on turns on arithabort only for the context.
As well as Marian's answer which is SQL Server Instance level, you can use ALTER DATABASE to set it individually. You can also use it on the model database so that all new databases inherit the settingTweet