数据库脚本:Database.sql

--Database.sql

use master
go

/*清理*/
if exists(select 1 from sysdatabases where name='EwEAI')
  drop database EwEAI
go

/*开始生成*/
create database EwEAI
on
primary(name=F_Primary,
        filename='D:/EwEAI/database/primary.mdf',
        size=5MB,
        filegrowth=5MB
),
filegroup System  /*系统文件组*/
(
    name=F_System,
    filename='D:/EwEAI/database/system.ndf',
    size=5MB,
    filegrowth=5MB
),
filegroup Hr      /*Hr文件组*/
(
    name=F_Hr,
    filename='D:/EwEAI/database/hr.ndf',
    size=5MB,
    filegrowth=5MB
),
filegroup Sale   /*Sale文件组*/
(
    name=F_Sale,
    filename='D:/EwEAI/database/sale.ndf',
    size=5MB,
    filegrowth=5MB
)
go

--数据库配置
exec sp_dboption 'EwEAI','ANSI null default','true'
exec sp_dboption 'EwEAI','ANSI null','true'
exec sp_dboption 'EwEAI','ANSI warnings','true'
exec sp_dbotpion 'EwEAI','arithabort','true'