USE [master] GO
/****** Object: Database [TestToys] Script Date: 2/18/2023 3:36:18 AM ******/ CREATE DATABASE [TestToys] CONTAINMENT = NONE ON PRIMARY ( NAME = N'TestToys', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\TestToys.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ) LOG ON ( NAME = N'TestToys_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\TestToys_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB ) WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [TestToys].[dbo].[sp_fulltext_database] @action = 'enable' end GO
ALTER DATABASE [TestToys] SET ANSI_NULL_DEFAULT OFF GO
ALTER DATABASE [TestToys] SET ANSI_NULLS OFF GO
ALTER DATABASE [TestToys] SET ANSI_PADDING OFF GO
ALTER DATABASE [TestToys] SET ANSI_WARNINGS OFF GO
ALTER DATABASE [TestToys] SET ARITHABORT OFF GO
ALTER DATABASE [TestToys] SET AUTO_CLOSE ON GO
ALTER DATABASE [TestToys] SET AUTO_SHRINK OFF GO
ALTER DATABASE [TestToys] SET AUTO_UPDATE_STATISTICS ON GO
ALTER DATABASE [TestToys] SET CURSOR_CLOSE_ON_COMMIT OFF GO
ALTER DATABASE [TestToys] SET CURSOR_DEFAULT GLOBAL GO
ALTER DATABASE [TestToys] SET CONCAT_NULL_YIELDS_NULL OFF GO
ALTER DATABASE [TestToys] SET NUMERIC_ROUNDABORT OFF GO
ALTER DATABASE [TestToys] SET QUOTED_IDENTIFIER OFF GO
ALTER DATABASE [TestToys] SET RECURSIVE_TRIGGERS OFF GO
ALTER DATABASE [TestToys] SET ENABLE_BROKER GO
ALTER DATABASE [TestToys] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO
ALTER DATABASE [TestToys] SET DATE_CORRELATION_OPTIMIZATION OFF GO
ALTER DATABASE [TestToys] SET TRUSTWORTHY OFF GO
ALTER DATABASE [TestToys] SET ALLOW_SNAPSHOT_ISOLATION OFF GO
ALTER DATABASE [TestToys] SET PARAMETERIZATION SIMPLE GO
ALTER DATABASE [TestToys] SET READ_COMMITTED_SNAPSHOT OFF GO
ALTER DATABASE [TestToys] SET HONOR_BROKER_PRIORITY OFF GO
ALTER DATABASE [TestToys] SET RECOVERY SIMPLE GO
ALTER DATABASE [TestToys] SET MULTI_USER GO
ALTER DATABASE [TestToys] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [TestToys] SET DB_CHAINING OFF GO
ALTER DATABASE [TestToys] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO
ALTER DATABASE [TestToys] SET TARGET_RECOVERY_TIME = 60 SECONDS GO
ALTER DATABASE [TestToys] SET DELAYED_DURABILITY = DISABLED GO
ALTER DATABASE [TestToys] SET ACCELERATED_DATABASE_RECOVERY = OFF
GO
ALTER DATABASE [TestToys] SET QUERY_STORE = ON GO
ALTER DATABASE [TestToys] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON) GO
ALTER DATABASE [TestToys] SET READ_WRITE GO