I keep getting an error in my .SqlDataProvider files. I also get the same error if I try to run the file by loading it through the "SQL" menu item under host.

The problem appears to occur near the word "GO" in my scripts.

I am using DNN 4.5.3 and have I saved the .SqlDataProvider files as text with UTF-8 encoding. I am using SQL Server 2005 (Free/Express Edition)

I can run individual lines of the script if I strip out the "GO" keywords and the script runs fine under SQL Server Management Studio.

I'm baffled. Can someone give me a clue as to what is going on.

As an example:

THIS DOES NOT RUN:

if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}MingHsueh_AddInstitution]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 drop procedure {databaseOwner}[{objectQualifier}MingHsueh_AddInstitution]
GO

I get There is an error in your query!

However this runs fine.

if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}MingHsueh_AddInstitution]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 drop procedure {databaseOwner}[{objectQualifier}MingHsueh_AddInstitution]

Thanks to anyone who can help.

Just to document why I was getting the error so in case it comes up again.

For some reason I was typing in "GO <Hard Return>" instead of "GO<Hard Return>", note the space between the GO and the <Hard Return>. Believe it or not, it was the space that was causing my error to appear.

Once I removed that space (and believe me seeing a blank space is not an easy task). The scripts worked fine. Strange but true. But thought I'd post my solution as an FYI.