I am trying to execute an SQL script that creates a database and when I do I
receive the following errors...
Error 26204. Error -2147217900: failed to execute SQL string, error detail:
Incorrect syntax near '»'., SQL key: CreateDatabase SQL string: USE
[master]
The CreateDatabase.sql code is...
USE [master]
GO
DECLARE @data_path nvarchar(256);
DECLARE @debug_message nvarchar(2048)
SET @debug_message = ''
IF NOT EXISTS(SELECT NAME FROM SYSDATABASES WHERE NAME = 'MVDB') AND
@data_path = ' '
BEGIN
SET @data_path = (SELECT SUBSTRING(filename, 1,
CHARINDEX('master.mdf',
LOWER(filename)) - 1)
FROM master.dbo.sysdatabases
WHERE name = 'master');
SET @data_path = @data_path + 'mvdb.mdf';
IF NOT EXISTS(SELECT NAME FROM SYSDATABASES WHERE NAME = 'MVDB')
BEGIN
CREATE DATABASE [mvdb]
IF @@ERROR = 0
BEGIN
EXEC dbo.sp_dbcmptlevel @dbname='mvdb',
@new_cmptlevel=100
IF (1 =
FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
BEGIN
EXEC
[mvdb].[dbo].[sp_fulltext_database] @action = 'enable'
END
ALTER DATABASE [mvdb] SET ANSI_NULL_DEFAULT OFF
ALTER DATABASE [mvdb] SET ANSI_NULLS OFF
ALTER DATABASE [mvdb] SET ANSI_PADDING OFF
ALTER DATABASE [mvdb] SET ANSI_WARNINGS OFF
ALTER DATABASE [mvdb] SET ARITHABORT OFF
ALTER DATABASE [mvdb] SET AUTO_CLOSE ON
ALTER DATABASE [mvdb] SET
AUTO_CREATE_STATISTICS ON
ALTER DATABASE [mvdb] SET AUTO_SHRINK OFF
ALTER DATABASE [mvdb] SET
AUTO_UPDATE_STATISTICS ON
ALTER DATABASE [mvdb] SET
CURSOR_CLOSE_ON_COMMIT OFF
ALTER DATABASE [mvdb] SET CURSOR_DEFAULT
GLOBAL
ALTER DATABASE [mvdb] SET
CONCAT_NULL_YIELDS_NULL OFF
ALTER DATABASE [mvdb] SET NUMERIC_ROUNDABORT
OFF
ALTER DATABASE [mvdb] SET QUOTED_IDENTIFIER OFF
ALTER DATABASE [mvdb] SET RECURSIVE_TRIGGERS
OFF
ALTER DATABASE [mvdb] SET READ_WRITE
ALTER DATABASE [mvdb] SET RECOVERY SIMPLE
ALTER DATABASE [mvdb] SET MULTI_USER
END
END
END
As you can see there are no garbage characters ( ) at the beginning of
the procedure.
Do I have to embed the code for each procedure or is there a way to use an
external file?
Thanks,
Gary
--
View this message in context:
http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/When-trying-to-execute-a-SQL-script-there-are-garbage-characters-tp7596247.html
Sent from the wix-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
WiX-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users
