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

2008-10-07 Thread Artie Leech
> > 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? > &g

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

2008-10-03 Thread Artie Leech
Thanks Bob - I wasn't really aware of MSBuild, but I am now. So I now use msbuild [options] and it works fine. Thanks! Artie Bob Archer wrote: > > I think that's the only option yes. Can you not use MSBuild? > > BOb > > > -Original Message- >

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:[

[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

[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