Hi,

I want to create a set of procedures through my application on SQL Server, through ADO.

My Scipts is something of the form:

Use DB1
Go
create procedure <procedurename>
as
< procedure text>
Go

Create Procedure <procedurename>
as
<procedure text>
Go

But when I execute this statement it gives error 'Error in line 2 Go'

Is there a way to excute this script in a single call or I have to make multiple calls.

Thanks
Pushkar

Instead of GO use a semicol for this:

Use DB1;
create procedure <procedurename> ...

HTH, Jens Suessmeyer.

Jens (J***@sqlserver2005.de) writes:

   use tempdb;
   CREATE PROCEDURE blafs AS
   SELECT 'Uhuh'

gives:

   Server: Msg 111, Level 15, State 1, Line 2
   'CREATE PROCEDURE' must be the first statement in a query batch.

; is a statement terminator, handled by SQL Server.

GO is a batch terminator, handled client-side by some query tools.

GO and ; fills different purposes.

You can't pass GO through ADO, as GO isn't a SQL command. For each GO, do an .Execute of your
command object.

I want to create a set of procedures through my application on SQL Server, through ADO.

My Scipts is something of the form:

Use DB1
Go
create procedure <procedurename>
as
< procedure text>
Go

Create Procedure <procedurename>
as
<procedure text>
Go

But when I execute this statement it gives error 'Error in line 2 Go'

Is there a way to excute this script in a single call or I have to make multiple calls.

Thanks
Pushkar

INSERT table (column1, column2) (@variable, '100')
Simple JOIN turned ugly - Help!
Is the SQL Server Service Running?
Grouping,Paging Logic
sORTING ACROSS MULTIPLE COLUMN