براي ساخت ديتا بيست تو اسكيو ال از اين دوتا اسكريپت استفاده كن .
کد:
USE [master]
GO
/****** Object: Database [NTTacDB] Script Date: 08/19/2010 12:17:19 ******/
CREATE DATABASE [NTTacDB] ON PRIMARY
( NAME = N'NTTacDB', FILENAME = N'D:\Nttac Db\NTTacDB.mdf' , SIZE = 11264KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'NTTacDB_log', FILENAME = N'D:\Nttac Db\NTTacDB_log.ldf' , SIZE = 26816KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'NTTacDB', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [NTTacDB].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [NTTacDB] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [NTTacDB] SET ANSI_NULLS OFF
GO
ALTER DATABASE [NTTacDB] SET ANSI_PADDING OFF
GO
ALTER DATABASE [NTTacDB] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [NTTacDB] SET ARITHABORT OFF
GO
ALTER DATABASE [NTTacDB] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [NTTacDB] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [NTTacDB] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [NTTacDB] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [NTTacDB] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [NTTacDB] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [NTTacDB] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [NTTacDB] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [NTTacDB] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [NTTacDB] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [NTTacDB] SET DISABLE_BROKER
GO
ALTER DATABASE [NTTacDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [NTTacDB] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [NTTacDB] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [NTTacDB] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [NTTacDB] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [NTTacDB] SET READ_WRITE
GO
ALTER DATABASE [NTTacDB] SET RECOVERY FULL
GO
ALTER DATABASE [NTTacDB] SET MULTI_USER
GO
ALTER DATABASE [NTTacDB] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [NTTacDB] SET DB_CHAINING OFF
<br/>
کد:
USE [master]
GO
/****** Object: Database [State] Script Date: 08/19/2010 12:17:33 ******/
CREATE DATABASE [State] ON PRIMARY
( NAME = N'State', FILENAME = N'D:\Nttac Db\State.mdf' , SIZE = 62464KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'State_log', FILENAME = N'D:\Nttac Db\State_log.ldf' , SIZE = 136064KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'State', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [State].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [State] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [State] SET ANSI_NULLS OFF
GO
ALTER DATABASE [State] SET ANSI_PADDING OFF
GO
ALTER DATABASE [State] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [State] SET ARITHABORT OFF
GO
ALTER DATABASE [State] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [State] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [State] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [State] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [State] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [State] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [State] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [State] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [State] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [State] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [State] SET DISABLE_BROKER
GO
ALTER DATABASE [State] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [State] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [State] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [State] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [State] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [State] SET READ_WRITE
GO
ALTER DATABASE [State] SET RECOVERY FULL
GO
ALTER DATABASE [State] SET MULTI_USER
GO
ALTER DATABASE [State] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [State] SET DB_CHAINING OFF
مجوز های ارسال و ویرایش
LinkBack URL
About LinkBacks
