Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
- ALTER DATABASE <dbname> SET READ_COMMITTED_SNAPSHOT ON;
- ALTER DATABASE <dbname> SET MULTI_USER;
- ALTER DATABASE [dbname] SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK AFTER 20 SECONDS
Add Comment
Please, Sign In to add comment