sqlserver 创建数据库、登录名、数据库用户、建库步骤

CREATE DATABASE [navtech] ON PRIMARY
( NAME = N'navtech', FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\navtech.mdf' , SIZE = 102400KB , FILEGROWTH = 10%)
LOG ON
( NAME = N'navtech_log', FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\navtech_log.ldf' , SIZE = 51200KB , FILEGROWTH = 10%)
GO
ALTER DATABASE [navtech] SET COMPATIBILITY_LEVEL = 100
GO
ALTER DATABASE [navtech] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [navtech] SET ANSI_NULLS OFF
GO
ALTER DATABASE [navtech] SET ANSI_PADDING OFF
GO
ALTER DATABASE [navtech] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [navtech] SET ARITHABORT OFF
GO
ALTER DATABASE [navtech] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [navtech] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [navtech] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [navtech] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [navtech] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [navtech] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [navtech] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [navtech] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [navtech] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [navtech] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [navtech] SET DISABLE_BROKER
GO
ALTER DATABASE [navtech] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [navtech] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [navtech] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [navtech] SET READ_WRITE
GO
ALTER DATABASE [navtech] SET RECOVERY FULL
GO
ALTER DATABASE [navtech] SET MULTI_USER
GO
ALTER DATABASE [navtech] SET PAGE_VERIFY CHECKSUM
GO
USE [navtech]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [navtech] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO