Guys @aksh1yadav @vvaidya @beesheep @Vikas.Jain @andrzej.kniola,
I have a stored procedure starting as below in a .sql file,
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
GO
IF OBJECT_ID(‘SP_ABCDEF’) IS NULL
EXEC(‘CREATE PROCEDURE DBO.SP_ABCDEF’)
GO
ALTER PROCEDURE DBO.SP_ABCDEF
AS
BEGIN
blah blah blah
GO
when I read this file and pass the content as query string to execute query activity, I see the below
error,
.Net SqlClient Data Provider : Incorrect syntax near 'GO’
Incorrect syntax near the keyword ‘ALTER’.
’CREATE/ALTER PROCEDURE’ must be the first statement in a query batch.
I don’t want to change anything and just run it as it is in the SQL file… Please see if you guys can share your thoughts around this,
Thanks!