Tagged Questions

4
votes
3answers
407 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 ...
1
vote
1answer
341 views

Can IMPLICIT_TRANSACTIONS set on database level?

When I have to investigate problems caused by IMPLICIT_TRANSACTIONS ON, can I focus on Client tools setting IMPLICIT_TRANSACTIONS ON or ANSI_DEFAULTS ON or can this be set for the whole database ...