123456 |
- USE [master]
- IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = N'callmaster') CREATE DATABASE [callmaster]
- IF EXISTS (SELECT name FROM sys.databases WHERE name = N'callmaster') ALTER DATABASE [callmaster] MODIFY FILE ( NAME = N'callmaster' , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
- IF EXISTS (SELECT name FROM sys.databases WHERE name = N'callmaster') ALTER DATABASE [callmaster] MODIFY FILE ( NAME = N'callmaster_log' , MAXSIZE = UNLIMITED , FILEGROWTH = 10%)
- IF EXISTS (SELECT name FROM sys.databases WHERE name = N'callmaster') ALTER DATABASE [callmaster] SET AUTO_SHRINK ON
- IF EXISTS (SELECT name FROM sys.databases WHERE name = N'callmaster') ALTER DATABASE [callmaster] SET RECOVERY SIMPLE
|