DATABASE 생선 옵션

SQL2005, 2008 생성 옵션,,, model database에 설정해 놓으면 편안할 듯

 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

             EXEC [JUDYDBA].[dbo].[sp_fulltext_database] @action = 'disable'

end

GO

 ALTER DATABASE [JUDYDBA] SET AUTO_CREATE_STATISTICS ON

GO

ALTER DATABASE [JUDYDBA] SET AUTO_UPDATE_STATISTICS ON

GO

ALTER DATABASE [JUDYDBA] SET AUTO_SHRINK OFF

GO

ALTER DATABASE [JUDYDBA] SET PAGE_VERIFY CHECKSUM 

GO

ALTER DATABASE [JUDYDBA] SET AUTO_UPDATE_STATISTICS_ASYNC ON

GO