use master;

ALTER DATABASE CES_CLOUD_SAAS_APP SET SINGLE_USER WITH ROLLBACK IMMEDIATE ; 
ALTER DATABASE CES_CLOUD_SAAS_APP SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE CES_CLOUD_SAAS_APP SET READ_COMMITTED_SNAPSHOT ON; 
ALTER DATABASE CES_CLOUD_SAAS_APP SET MULTI_USER;

ALTER DATABASE CES_CLOUD_SAAS_CHECK SET SINGLE_USER WITH ROLLBACK IMMEDIATE ; 
ALTER DATABASE CES_CLOUD_SAAS_CHECK SET ALLOW_SNAPSHOT_ISOLATION ON; 
ALTER DATABASE CES_CLOUD_SAAS_CHECK SET READ_COMMITTED_SNAPSHOT ON; 
ALTER DATABASE CES_CLOUD_SAAS_CHECK SET MULTI_USER;

ALTER DATABASE CES_CLOUD_SAAS_DS SET SINGLE_USER WITH ROLLBACK IMMEDIATE ; 
ALTER DATABASE CES_CLOUD_SAAS_DS SET ALLOW_SNAPSHOT_ISOLATION ON; 
ALTER DATABASE CES_CLOUD_SAAS_DS SET READ_COMMITTED_SNAPSHOT ON; 
ALTER DATABASE CES_CLOUD_SAAS_DS SET MULTI_USER;

ALTER DATABASE CES_CLOUD_SAAS_INDEX SET SINGLE_USER WITH ROLLBACK IMMEDIATE ; 
ALTER DATABASE CES_CLOUD_SAAS_INDEX SET ALLOW_SNAPSHOT_ISOLATION ON; 
ALTER DATABASE CES_CLOUD_SAAS_INDEX SET READ_COMMITTED_SNAPSHOT ON; 
ALTER DATABASE CES_CLOUD_SAAS_INDEX SET MULTI_USER;

ALTER DATABASE CES_CLOUD_SAAS_MAINPAGE SET SINGLE_USER WITH ROLLBACK IMMEDIATE ; 
ALTER DATABASE CES_CLOUD_SAAS_MAINPAGE SET ALLOW_SNAPSHOT_ISOLATION ON; 
ALTER DATABASE CES_CLOUD_SAAS_MAINPAGE SET READ_COMMITTED_SNAPSHOT ON; 
ALTER DATABASE CES_CLOUD_SAAS_MAINPAGE SET MULTI_USER;

ALTER DATABASE CES_CLOUD_SAAS_MANAGEMENT SET SINGLE_USER WITH ROLLBACK IMMEDIATE ; 
ALTER DATABASE CES_CLOUD_SAAS_MANAGEMENT SET ALLOW_SNAPSHOT_ISOLATION ON; 
ALTER DATABASE CES_CLOUD_SAAS_MANAGEMENT SET READ_COMMITTED_SNAPSHOT ON; 
ALTER DATABASE CES_CLOUD_SAAS_MANAGEMENT SET MULTI_USER;

ALTER DATABASE CES_CLOUD_SAAS_STORAGE SET SINGLE_USER WITH ROLLBACK IMMEDIATE ; 
ALTER DATABASE CES_CLOUD_SAAS_STORAGE SET ALLOW_SNAPSHOT_ISOLATION ON; 
ALTER DATABASE CES_CLOUD_SAAS_STORAGE SET READ_COMMITTED_SNAPSHOT ON; 
ALTER DATABASE CES_CLOUD_SAAS_STORAGE SET MULTI_USER;

ALTER DATABASE CES_CLOUD_SAAS_SYS SET SINGLE_USER WITH ROLLBACK IMMEDIATE ; 
ALTER DATABASE CES_CLOUD_SAAS_SYS SET ALLOW_SNAPSHOT_ISOLATION ON; 
ALTER DATABASE CES_CLOUD_SAAS_SYS SET READ_COMMITTED_SNAPSHOT ON; 
ALTER DATABASE CES_CLOUD_SAAS_SYS SET MULTI_USER;

ALTER DATABASE db_0 SET SINGLE_USER WITH ROLLBACK IMMEDIATE ; 
ALTER DATABASE db_0 SET ALLOW_SNAPSHOT_ISOLATION ON; 
ALTER DATABASE db_0 SET READ_COMMITTED_SNAPSHOT ON; 
ALTER DATABASE db_0 SET MULTI_USER;

