We are currently attempting to run a SQL script against a SQL Server 2000. We can successfully create a new database if the create database if absent checkbox is selected, however the script to create/update tables will not execute. If we select the Abort execution on script error checkbox, the return result variable does return ERROR, but if we run the script in Query Analyser it runs without error.
Here is the code from mia file
Hunter,,KARYN1,,,KARYN,"if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblTest]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)$NEWLINE$drop table [dbo].[tblTest]$NEWLINE$GO$NEWLINE$CREATE TABLE [dbo].[tblTest] ([Testid] [int] IDENTITY (1, 1) NOT NULL) ON [PRIMARY]$NEWLINE$GO$NEWLINE$$NEWLINE$",0,-1
mMSSQLIDE.dll\\mMSSQLExec.dll
We are using InstallAware version 6
Any help would be appreciated.
Regards
SQL Server scripts
Who is online
Users browsing this forum: No registered users and 154 guests