USE master;
GO
IF DB_ID (N'lesstif') IS NOT NULL
DROP DATABASE lesstif;
GO
CREATE DATABASE lesstif;
GO
-- Verify the database files and sizes
SELECT name, size, size*1.0/128 AS [Size in MBs]
FROM sys.master_files
WHERE name = N'lesstif';
GO
SQL
사용자
USE lesstif;
GRANT CONTROL ON DATABASE::lesstif TO lesstif;
GO
SQL
사용자에게 CREATE DB 권한 부여
USE lesstif;
GRANT CREATE DATABASE TO [lesstif];
GO