Tagged Questions
4
votes
3answers
401 views
SQL Server making arithmetic abort enabled
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 ...
2
votes
1answer
274 views
Why is 'Allow Snapshot Isolation' set to TRUE on the master and msdb databases?
Why is the database property Allow Snapshot Isolation set to TRUE on the master and msdb databases, but FALSE on other system databases? The default option for this property is also FALSE when ...
