code_junkie

How programaticaly enable READ COMMITTED SNAPSHOT in SQL Server?

Nov 12th, 2011
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
  2. ALTER DATABASE <dbname> SET READ_COMMITTED_SNAPSHOT ON;
  3. ALTER DATABASE <dbname> SET MULTI_USER;
  4.  
  5. ALTER DATABASE [dbname] SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK AFTER 20 SECONDS
Add Comment
Please, Sign In to add comment