USE [master]
GO
IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = N'stuDB')
BEGIN
CREATE DATABASE [stuDB] ON PRIMARY
( NAME = N'stuDB', FILENAME = N'D:\project\stuDB.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 15%)
LOG ON
( NAME = N'stuDB_log', FILENAME = N'D:\project\stuDB_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 15%)
END
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'stuDB', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [stuDB].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [stuDB] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [stuDB] SET ANSI_NULLS OFF
GO
ALTER DATABASE [stuDB] SET ANSI_PADDING OFF
GO
ALTER DATABASE [stuDB] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [stuDB] SET ARITHABORT OFF
GO
ALTER DATABASE [stuDB] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [stuDB] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [stuDB] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [stuDB] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [stuDB] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [stuDB] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [stuDB] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [stuDB] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [stuDB] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [stuDB] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [stuDB] SET DISABLE_BROKER
GO
ALTER DATABASE [stuDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [stuDB] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [stuDB] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [stuDB] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [stuDB] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [stuDB] SET READ_WRITE
GO
ALTER DATABASE [stuDB] SET RECOVERY FULL
GO
ALTER DATABASE [stuDB] SET MULTI_USER
GO
ALTER DATABASE [stuDB] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [stuDB] SET DB_CHAINING OFF
GO
USE [stuDB]
GO
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'banzhuren')
CREATE USER [banzhuren] FOR LOGIN [banzhuren] WITH DEFAULT_SCHEMA=[dbo]
GO
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'teacher')
CREATE USER [teacher] FOR LOGIN [teacher] WITH DEFAULT_SCHEMA=[dbo]
GO
GRANT CONNECT TO [banzhuren]
GO
GRANT CONNECT TO [teacher]
/* For security reasons the login is created disabled and with a random password. */
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'teacher')
CREATE LOGIN [teacher] WITH PASSWORD=N'-p¨K~õí¨÷-J,f¥V®b[qäÄxµ<', DEFAULT_DATABASE=[stuDB], DEFAULT_LANGUAGE=[简体中文], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [teacher] DISABLE
GO
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'NT AUTHORITY\SYSTEM')
CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[简体中文]
GO
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'BUILTIN\Administrators')
CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[简体中文]
GO
/* For security reasons the login is created disabled and with a random password. */
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'banzhuren')
CREATE LOGIN [banzhuren] WITH PASSWORD=N'G©â%dO£Å=½sU [
¤æ
®YôØÀ', DEFAULT_DATABASE=[stuDB], DEFAULT_LANGUAGE=[简体中文], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [banzhuren] DISABLE
GO
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'20081007-0952\SQLServer2005SQLAgentUser$20081007-0952$MSSQLSERVER')
CREATE LOGIN [20081007-0952\SQLServer2005SQLAgentUser$20081007-0952$MSSQLSERVER] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[简体中文]
GO
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'20081007-0952\SQLServer2005MSSQLUser$20081007-0952$MSSQLSERVER')
CREATE LOGIN [20081007-0952\SQLServer2005MSSQLUser$20081007-09�
北大青鸟 数据库 源代码 第一学期
需积分: 9 31 浏览量
2008-11-08
20:51:53
上传
评论
收藏 1017KB RAR 举报
project.rar （5个子文件） 
project 
stuDB.mdf 3MB 081108-s1-sql-query-刘猛.sql 3KB stuDB_log.ldf 1024KB 081108-s1-sql-project-刘猛.sql 21KB
081108-s1-sql-project-刘猛.xls 12KB
评论0