|
|
USE [master]
GO
/****** Object: Database [WCFDataServicesDemoApp] Script Date: 02/05/2010 07:06:31 ******/
CREATE DATABASE [WCFDataServicesDemoApp] ON PRIMARY
( NAME = N'WCFDataServicesDemoApp', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\WCFDataServicesDemoApp.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'WCFDataServicesDemoApp_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\WCFDataServicesDemoApp_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
COLLATE Latin1_General_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'WCFDataServicesDemoApp', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [WCFDataServicesDemoApp].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET ANSI_NULLS OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET ANSI_PADDING OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET ARITHABORT OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET ENABLE_BROKER
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET READ_WRITE
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET RECOVERY FULL
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET MULTI_USER
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [WCFDataServicesDemoApp] SET DB_CHAINING OFF
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I currently hold the following qualifications (amongst others, I also studied Music Technology and Electronics, for my sins)
- MSc (Passed with distinctions), in Information Technology for E-Commerce
- BSc Hons (1st class) in Computer Science & Artificial Intelligence
Both of these at Sussex University UK.
Award(s)
I am lucky enough to have won a few awards for Zany Crazy code articles over the years
- Microsoft C# MVP 2016
- Codeproject MVP 2016
- Microsoft C# MVP 2015
- Codeproject MVP 2015
- Microsoft C# MVP 2014
- Codeproject MVP 2014
- Microsoft C# MVP 2013
- Codeproject MVP 2013
- Microsoft C# MVP 2012
- Codeproject MVP 2012
- Microsoft C# MVP 2011
- Codeproject MVP 2011
- Microsoft C# MVP 2010
- Codeproject MVP 2010
- Microsoft C# MVP 2009
- Codeproject MVP 2009
- Microsoft C# MVP 2008
- Codeproject MVP 2008
- And numerous codeproject awards which you can see over at my blog
Submit an article or tip