Ребята, приветствую! Нужна помощь!
При попытке создать базу данных для веб-магазина, получаю ошибку о синтаксисе.
USE [master
GO /****** Object: Database [PS_UserData] Script Date: 7/25/2015 8:25:34 PM ******/ CRE ATE DATABASE [PS_UserData] CONTAINMENT = NONE ON PRIMARY ( NAME = N'donate_items', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\donate_items.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'donate_items_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\donate_items_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO ALT ER DATABASE [PS_UserData] SET COMPATIBILITY_LEVEL = 110 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [PS_UserData].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALT ER DATABASE [PS_UserData] SET ANSI_NULL_DEFAULT OFF GO ALT ER DATABASE [PS_UserData] SET ANSI_NULLS OFF GO ALT ER DATABASE [PS_UserData] SET ANSI_PADDING OFF GO ALT ER DATABASE [PS_UserData] SET ANSI_WARNINGS OFF GO ALT ER DATABASE [PS_UserData] SET ARITHABORT OFF GO ALT ER DATABASE [PS_UserData] SET AUTO_CLOSE OFF GO ALT ER DATABASE [PS_UserData] SET AUTO_CREATE_STATISTICS ON GO ALT ER DATABASE [PS_UserData] SET AUTO_SHRINK OFF GO ALT ER DATABASE [PS_UserData] SET AUTO_UPDATE_STATISTICS ON GO ALT ER DATABASE [PS_UserData] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALT ER DATABASE [PS_UserData] SET CURSOR_DEFAULT GLOBAL GO ALT ER DATABASE [PS_UserData] SET CONCAT_NULL_YIELDS_NULL OFF GO ALT ER DATABASE [PS_UserData] SET NUMERIC_ROUNDABORT OFF GO ALT ER DATABASE [PS_UserData] SET QUOTED_IDENTIFIER OFF GO ALT ER DATABASE [PS_UserData] SET RECURSIVE_TRIGGERS OFF GO ALT ER DATABASE [PS_UserData] SET DISABLE_BROKER GO ALT ER DATABASE [PS_UserData] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALT ER DATABASE [PS_UserData] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALT ER DATABASE [PS_UserData] SET TRUSTWORTHY OFF GO ALT ER DATABASE [PS_UserData] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALT ER DATABASE [PS_UserData] SET PARAMETERIZATION SIMPLE GO ALT ER DATABASE [PS_UserData] SET READ_COMMITTED_SNAPSHOT OFF GO ALT ER DATABASE [PS_UserData] SET HONOR_BROKER_PRIORITY OFF GO ALT ER DATABASE [PS_UserData] SET RECOVERY SIMPLE GO ALT ER DATABASE [PS_UserData] SET MULTI_USER GO ALT ER DATABASE [PS_UserData] SET PAGE_VERIFY CHECKSUM GO ALT ER DATABASE [PS_UserData] SET DB_CHAINING OFF GO ALT ER DATABASE [PS_UserData] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO ALT ER DATABASE [PS_UserData] SET TARGET_RECOVERY_TIME = 0 SECONDS GO ALT ER DATABASE [PS_UserData] SET READ_WRITE GO]Скрытый текст
Установлен Server 2008R2, как я понимаю, запрос под 2012 и выше.
Пробовал сделать так, как описано тут и тоже - безуспешно.
Получаю ошибку эту
Msg 102, Level 15, State 1, Line 4 Incorrect syntax near 'CONTAINMENT'. Msg 102, Level 15, State 6, Line 2 Incorrect syntax near 'FILESTREAM'. Msg 102, Level 15, State 6, Line 2 Incorrect syntax near 'TARGET_RECOVERY_TIME'.