[2k5] DB 옵션 변경 및 설정

1. /**********************************************************************************************
   -- Title : [2k5] DB 옵션 변경 및 설정
   -- Reference : hanbitbook.co.kr
   -- Key word : set auto_shrink restricted_user emergency single_user read_only
   **********************************************************************************************/
   USE master;
   go
    
   IF EXISTS(SELECT * FROM master.dbo.sysdatabases WHERE name = 'hanbitDB')
      DROP DATABASE hanbitDB;
    
   -- DB 생성
   CREATE DATABASE hanbitDB;
    
   -- DB 자동 축소
   ALTER DATABASE hanbitDB
   SET AUTO_SHRINK ON;
    
   -- DB 가동 상태{ ONLINE | OFFLINE | EMERGENCY }
   ALTER DATABASE hanbitDB
   SET EMERGENCY;
    
   -- DB 사용자{ SINGLE_USER | RESTRICTED_USER | MULTI_USER }
   ALTER DATABASE hanbitDB
   SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    
   -- DB 읽기 전용{ READ_ONLY | READ_WRITE }
   ALTER DATABASE hanbitDB
   SET READ_ONLY;