QUESTION
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.
I assume set arithabort off and set arithabort on turns on arithabort only for the context.
ANSWER
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 setting
Tweet