I am using SQL Server 2008.
In my stored procedures, 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.