sql-server transactions isolation-level read-committed-snapshot

How programmatically enable READ COMMITTED SNAPSHOT in SQL Server?

I need to programmatically enable READ COMMITTED SNAPSHOT in SQL Server. How can I do that?

Solution

ALTER DATABASE [dbname] SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK AFTER 20 SECONDS

Updating and join on multiple rows, which row's value is used?
What changed about the Statement.execute() between sqljdbc4 and mssql-jdbc?
Varchar datetime with EDT in it convert into datetime
LINQ: Why does a union of a union throw error message "IQueryable<...> does not contain a definition for 'Union'"?
SQL Logic doesn't work
Aggregation: Category missing in SQL subquery
Error copying data from SQL Server to Redshift via a linked server connection
Backup SQL Schema Only?
Row wise average in SQL Server
a *FUTUREPROOF* Project reference, to connect to SQL Server?
Error for Invalid length parameter passed to SUBSTRING function
Why is Query Optimizer Underestimating and Causing Data Spill to tempdb?
SQL Server Management Studio Schema View
Drop User from SQL Server Database?
Create failed for Database
SQL Server Express localdb.msi offline installer
Loading data into SQL Server using Pandas dataframe
Data has always changed(SQL Server Management Studio)
SQL Server : generate random numeric string 27 characters long
SQL Server Restore Error: Directory lookup for the file "db.mdf" failed
Use dynamic database name in a stored procedure
Why Does SQL Update Top apparently reduce locking even when no records are updated?
"Type character does not declare data type" error
Stopping repeated XML Headers
C# filling a dataset from the database
Microsoft SQL join on longitudinal data
Add SSIS to existing SQL Server instance
Cannot start LocalDB
Remove all spaces from a string in SQL Server
How to check the existence of related records in group by query?