The options tag has no wiki summary.
4
votes
3answers
160 views
What methods are available to create a snapshot of an oracle database for testing purposes?
I am new to databases and have just been assigned to work with Oracle. We want to create a snapshot of the database for testing purposes that will allow us to revert back once we're done.
I'm a bit ...
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 ...
2
votes
1answer
278 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 ...
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 ...
