Sql Error-,-

Results 1 to 1 of 1
  1. #1
    Valued Member Husk is offline
    MemberRank
    Feb 2007 Join Date
    The NetherlandsLocation
    140Posts

    Sql Error-,-

    Msg 1801, Level 16, State 3, Line 2
    Database 'GunZDB' already exists.
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.


    Code:
     
    USE [master]
    GO
    /****** Object: Database [GunZDB] Script Date: 06/10/2007 03:31:41 ******/
    CREATE DATABASE [GunZDB] ON PRIMARY 
    ( NAME = N'GunZDB', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\GunZDB.mdf' , SIZE = 553984KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
    LOG ON 
    ( NAME = N'GunZDB_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\GunZDB_1.ldf' , SIZE = 6782720KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
    GO
    EXEC dbo.sp_dbcmptlevel @dbname=N'GunZDB', @new_cmptlevel=90
    GO
    IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
    begin
    EXEC [GunZDB].[dbo].[sp_fulltext_database] @action = 'disable'
    end
    GO
    ALTER DATABASE [GunZDB] SET ANSI_NULL_DEFAULT OFF 
    GO
    ALTER DATABASE [GunZDB] SET ANSI_NULLS OFF 
    GO
    ALTER DATABASE [GunZDB] SET ANSI_PADDING OFF 
    GO
    ALTER DATABASE [GunZDB] SET ANSI_WARNINGS OFF 
    GO
    ALTER DATABASE [GunZDB] SET ARITHABORT OFF 
    GO
    ALTER DATABASE [GunZDB] SET AUTO_CLOSE OFF 
    GO
    ALTER DATABASE [GunZDB] SET AUTO_CREATE_STATISTICS ON 
    GO
    ALTER DATABASE [GunZDB] SET AUTO_SHRINK OFF 
    GO
    ALTER DATABASE [GunZDB] SET AUTO_UPDATE_STATISTICS ON 
    GO
    ALTER DATABASE [GunZDB] SET CURSOR_CLOSE_ON_COMMIT OFF 
    GO
    ALTER DATABASE [GunZDB] SET CURSOR_DEFAULT GLOBAL 
    GO
    ALTER DATABASE [GunZDB] SET CONCAT_NULL_YIELDS_NULL OFF 
    GO
    ALTER DATABASE [GunZDB] SET NUMERIC_ROUNDABORT OFF 
    GO
    ALTER DATABASE [GunZDB] SET QUOTED_IDENTIFIER OFF 
    GO
    ALTER DATABASE [GunZDB] SET RECURSIVE_TRIGGERS OFF 
    GO
    ALTER DATABASE [GunZDB] SET DISABLE_BROKER 
    GO
    ALTER DATABASE [GunZDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
    GO
    ALTER DATABASE [GunZDB] SET DATE_CORRELATION_OPTIMIZATION OFF 
    GO
    ALTER DATABASE [GunZDB] SET TRUSTWORTHY OFF 
    GO
    ALTER DATABASE [GunZDB] SET ALLOW_SNAPSHOT_ISOLATION OFF 
    GO
    ALTER DATABASE [GunZDB] SET PARAMETERIZATION SIMPLE 
    GO
    ALTER DATABASE [GunZDB] SET READ_WRITE 
    GO
    ALTER DATABASE [GunZDB] SET RECOVERY FULL 
    GO
    ALTER DATABASE [GunZDB] SET MULTI_USER 
    GO
    ALTER DATABASE [GunZDB] SET PAGE_VERIFY CHECKSUM 
    GO
    ALTER DATABASE [GunZDB] SET DB_CHAINING OFF
    What i most do?




Advertisement