创建Develop数据库脚本及设置-CSDN博客

本文链接：https://blog.csdn.net/waterstar50/article/details/89372010

这段内容展示了创建名为'Develop'的数据库的详细脚本，包括数据文件和日志文件的位置、大小以及增长设置。同时，设置了数据库的兼容级别、全文搜索状态以及其他重要的数据库选项，如ANSI标准、事务隔离级别、恢复模式等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

USE [master]
GO

/****** Object: Database [Develop] Script Date: 04/13/2019 16:55:30 ******/
CREATE DATABASE [Develop] ON PRIMARY
( NAME = N’Develop’, FILENAME = N’D:\DB\Client\Develop.mdf’ , SIZE = 11264KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N’Develop_log’, FILENAME = N’D:\DB\Client\Develop_log.ldf’ , SIZE = 10176KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

ALTER DATABASE [Develop] SET COMPATIBILITY_LEVEL = 100
GO

IF (1 = FULLTEXTSERVICEPROPERTY(‘IsFullTextInstalled’))
begin
EXEC [Develop].[dbo].[sp_fulltext_database] @action = ‘enable’
end
GO

ALTER DATABASE [Develop] SET ANSI_NULL_DEFAULT OFF
GO

ALTER DATABASE [Develop] SET ANSI_NULLS OFF
GO

ALTER DATABASE [Develop] SET ANSI_PADDING OFF
GO

ALTER DATABASE [Develop] SET ANSI_WARNINGS OFF
GO

ALTER DATABASE [Develop] SET ARITHABORT OFF
GO

ALTER DATABASE [Develop] SET AUTO_CLOSE OFF
GO

ALTER DATABASE [Develop] SET AUTO_CREATE_STATISTICS ON
GO

ALTER DATABASE [Develop] SET AUTO_SHRINK OFF
GO

ALTER DATABASE [Develop] SET AUTO_UPDATE_STATISTICS ON
GO

ALTER DATABASE [Develop] SET CURSOR_CLOSE_ON_COMMIT OFF
GO