Set SQL Server Isolation Level

Set snapshot isolation level on
Make sure all the connections to the database are closed!
ALTER DATABASE MyDB
SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE MyDB
SET READ_COMMITTED_SNAPSHOT ON

Check the isolation level
dbcc useroptions;

Set snapshot isolation level off (in case you have bad performance when turned on)
ALTER DATABASE MyDB
SET ALLOW_SNAPSHOT_ISOLATION OFF

ALTER DATABASE MyDB
SET READ_COMMITTED_SNAPSHOT OFF