Re: [NAnt-users] NAnt sql task fails, but code works in SQL Query Analyzer

2008-10-02 Thread Bob Archer
It's because [I think] you are using "Normal" delimiter. So, it sees GO in the word GOTO and assumes that is the end of the block and sends that to SQL. Can you change to use Line delimiter and make sure all your GO's are on their own line? BOb -Original Message- From: Artie Leech [mailt

Re: [NAnt-users] Using NAnt to invoke Visual Studio devenv - minimum fileset required?

2008-10-02 Thread Bob Archer
I think that's the only option yes. Can you not use MSBuild? BOb -Original Message- From: Artie Leech [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2008 10:53 AM To: nant-users@lists.sourceforge.net Subject: [NAnt-users] Using NAnt to invoke Visual Studio devenv - minimum filese

Re: [NAnt-users] NAnt sql task fails, but code works in SQL Query Analyzer

2008-10-02 Thread Artie Leech
Hi Bob, I tried putting a GO at the end, but I still get the same error. Any other ideas? Thanks, Artie Bob Archer wrote: > > Put a GO at the end of the file. I think that might resolve it. > > BOb > > > -Original Message- > From: Artie Leech [mailto:[EMAIL PROTECTED] > Sent: Thu

[NAnt-users] Using NAnt to invoke Visual Studio devenv - minimum fileset required?

2008-10-02 Thread Artie Leech
Hi, I'm using NAnt as part of my build process, and on my development machine I invoke devenv (part of Visual Studio) to perform a command line build. I also intend to use this on our Cruise Control Server. My question is, do I need to install a full version of Visual Studio 2005 just to get

Re: [NAnt-users] NAnt sql task fails, but code works in SQL Query Analyzer

2008-10-02 Thread Bob Archer
Put a GO at the end of the file. I think that might resolve it. BOb -Original Message- From: Artie Leech [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2008 6:34 AM To: nant-users@lists.sourceforge.net Subject: [NAnt-users] NAnt sql task fails, but code works in SQL Query Analyze

[NAnt-users] NAnt sql task fails, but code works in SQL Query Analyzer

2008-10-02 Thread Artie Leech
Hi, I'm trying to create a nant task that will build my database, which uses SQL Server 2000. I have the following line in a loop to load up a number of stored procs. It's trying to load the stored proc code shown at the bottom of this post. When I run my nant task, I get the following error