I have put this in the bug tracker, but Ian suggested that I email it out as well...
If I have the following SQL statements in a file going against a database on MS SQL 2000 -- Fix user accounts after database restore EXEC sp_configure 'allow updates', 1 RECONFIGURE WITH OVERRIDE go CREATE TABLE #syslogins ( sid varbinary (85) NULL , name sysname COLLATE database_default NULL ) INSERT #syslogins SELECT sid, name from master..sysxlogins UPDATE su SET sid = sl.sid FROM #syslogins sl JOIN sysusers su ON sl.name = su.name WHERE sl.sid != su.sid DROP TABLE #syslogins EXEC sp_configure 'allow updates', 0 RECONFIGURE WITH OVERRIDE go and execute it will the SQL task: BUILD FAILED SQL Resulted in Exception: Line 17: Incorrect syntax near 'go'. Line 3: Incorrect syntax near 'go'. Try 'nant -help' for more information To correct this I have to remove the GO statements, but I don't feel that I should have to remove the GO statements in my SQL. Thanks, Jason ------------------------------------------------------- This sf.net email is sponsored by: Jabber - The world's fastest growing real-time communications platform! Don't just IM. Build it in! http://www.jabber.com/osdn/xim _______________________________________________ NAntContrib-Developer mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/nantcontrib-developer
