Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,548 members, 7,955,038 topics. Date: Saturday, 21 September 2024 at 03:08 PM |
Nairaland Forum / Science/Technology / Programming / Sql Error Msg 1801, Level 16 During Execution In Ssms (1718 Views)
How To Import MSG Files To Outlook PST? / Top 20 Websites To Learn Coding With Java, Python, SQL, Algorithms, And Git For / Urgent Help Needed On How To Save Fingerprint To Sql Using U Are U 4500 And Java (2) (3) (4)
(1) (Reply)
Sql Error Msg 1801, Level 16 During Execution In Ssms by olulove(m): 8:06am On Oct 24, 2017 |
USE [master] GO /****** Object: Database [KNMIS] Script Date: 09/03/2016 06:00:23 ******/ CREATE DATABASE [KNMIS] ON PRIMARY ( NAME = N'KNMIS', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\KNMIS.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'KNMIS_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\KNMIS_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO ALTER DATABASE [KNMIS] SET COMPATIBILITY_LEVEL = 100 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [KNMIS].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [KNMIS] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [KNMIS] SET ANSI_NULLS OFF GO ALTER DATABASE [KNMIS] SET ANSI_PADDING OFF GO ALTER DATABASE [KNMIS] SET ANSI_WARNINGS OFF GO ALTER DATABASE [KNMIS] SET ARITHABORT OFF GO ALTER DATABASE [KNMIS] SET AUTO_CLOSE OFF GO ALTER DATABASE [KNMIS] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [KNMIS] SET AUTO_SHRINK OFF GO ALTER DATABASE [KNMIS] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [KNMIS] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [KNMIS] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [KNMIS] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [KNMIS] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [KNMIS] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [KNMIS] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [KNMIS] SET DISABLE_BROKER GO ALTER DATABASE [KNMIS] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [KNMIS] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [KNMIS] SET TRUSTWORTHY OFF GO ALTER DATABASE [KNMIS] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [KNMIS] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [KNMIS] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [KNMIS] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [KNMIS] SET READ_WRITE GO ALTER DATABASE [KNMIS] SET RECOVERY SIMPLE GO ALTER DATABASE [KNMIS] SET MULTI_USER GO ALTER DATABASE [KNMIS] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [KNMIS] SET DB_CHAINING OFF GO
|
(1) (Reply)
I Need A Programmer With A Lot Of Experience With Payment Gateways / I Need A Topic On Computer Science Projet That Deals With Java Programming / Accept Airtime Payment Using Hosted Sim, Automatically Credit The Users Units
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 16 |