SQL Server scripts

Got a problem you cannot solve? Try here.
BAS_01
Posts: 1
Joined: Tue Jun 20, 2006 9:13 pm

SQL Server scripts

Postby BAS_01 » Tue Jun 20, 2006 9:27 pm

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

Return to “Technical Support”

Who is online

Users browsing this forum: No registered users and 22 guests