Re: Executing a huge sql script
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
How many characters are the 10000 inserts? How do you pass the query? Tsql? Perhaps prepared statements have limits while standard (like SQLExecDirect) I doubt. Frediano Ziglio Il giorno 13/nov/2013, alle ore 01:19, Chris Kings-Lynne <[email protected]> ha scritto: > Hi Guys, > > I'm trying to execute a huge sql script via tsql and although it can execute from management studio, tsql just fails halfway though. There's no error, nothing. It just finishes its 10th set of 1000 inserts (with GO between) and simply chooses not to continue on with the next lot, in the same file. > > Is this something worth looking into? I could replace all the literal strings in my file with garbage for testing? The sql file is about 10MB or so. > > Chris > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds