Folgender Fehler tritt auf:
Code:
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[master]
PRINT '#############################################################' at line 1
[Err] USE [master]
PRINT '#########################################################################################
####################### Der volgende Code dient zum L�schen vorhandener ######
########################### Datenbanken und deren Log. #######################'
EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'CHARACTER_01_DBF'
GO
USE [master]
GO
/****** Object: Database [CHARACTER_01_DBF] Script Date: 11/24/2009 04:17:41 ******/
DROP DATABASE [CHARACTER_01_DBF]
EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'RANKING_DBF'
GO
USE [master]
GO
/****** Object: Database [CHARACTER_01_DBF] Script Date: 11/24/2009 04:17:41 ******/
DROP DATABASE [RANKING_DBF]
EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'ITEM_DBF'
GO
USE [master]
GO
/****** Object: Database [CHARACTER_01_DBF] Script Date: 11/24/2009 04:17:41 ******/
DROP DATABASE [LOGGING_01_DBF]
EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'ACCOUNT_DBF'
GO
USE [master]
GO
/****** Object: Database [CHARACTER_01_DBF] Script Date: 11/24/2009 04:17:41 ******/
DROP DATABASE [ACCOUNT_DBF]
/********* Verbindungsserver Vorab l�schung *****/
USE [master]
GO
EXEC master.dbo.sp_dropserver @server=N'ACCOUNT', @droplogins='droplogins'
GO
EXEC master.dbo.sp_dropserver @server=N'CHR01', @droplogins='droplogins'
GO
EXEC master.dbo.sp_dropserver @server=N'RANKING', @droplogins='droplogins'
GO
EXEC master.dbo.sp_dropserver @server=N'LOG01', @droplogins ='droplogins'
PRINT '#############################################################################
# Wenn der obrige Code als Fehlermeldung ausgegeben wird: Ignorieren! #
#######################################################################'
PRINT '#############################################################################
# If code of the authorities is issued as an error message: Ignore! #
#######################################################################'
PRINT '#################################
# Copyrights: #
# Based Database: Aeonsoft #
# AllInOne Script: Sedrika #
# Fix and Editing: Cross #
#################################'
GO
CREATE DATABASE [CHARACTER_01_DBF]
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'CHARACTER_01_DBF', @new_cmptlevel=80
GO
ALTER DATABASE [CHARACTER_01_DBF] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET ANSI_NULLS OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET ANSI_PADDING OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET ARITHABORT OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [CHARACTER_01_DBF] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [CHARACTER_01_DBF] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [CHARACTER_01_DBF] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [CHARACTER_01_DBF] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [CHARACTER_01_DBF] SET READ_WRITE
GO
ALTER DATABASE [CHARACTER_01_DBF] SET RECOVERY SIMPLE
GO
ALTER DATABASE [CHARACTER_01_DBF] SET MULTI_USER
GO
ALTER DATABASE [CHARACTER_01_DBF] SET PAGE_VERIFY CHECKSUM
GO
USE [CHARACTER_01_DBF]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [CHARACTER_01_DBF] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO
CREATE DATABASE [ACCOUNT_DBF]
GO
EXEC dbo.sp_dbcmptlevel @db
[Msg] Finished - Unsuccessfully
--------------------------------------------------
