Re: long SQL lines for osql

pb648174 (google@xxxxxxxxxxx) writes:
We have a very long and complicated SQL script which we run to upgrade
a version of our software from old to new. It works great in Query
Analyzer, but when run through osql it takes errors on lines that are
very long and (I think) stops reading after a certain amount of
characters. I've searched the net but haven't found anyone mentioning
this before. I have tried the -w 5000 parm to no avail.

-w controls the width of the output. As I understand it, you have
problems with the input.

One thing to keep in mind, is by default OSQL runs with QUOTED_IDENTIFIER
off, which is different from Query Analyzer. Run with -I to change this.

It would have helped if you had included any error messages.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Immer noch Probleme mit dem Debugger
    ... Client (Query Analyzer) und SQL Server nicht auf der gleichen Maschine ... Gezielt gesetzte Haltepunkte waren dem Debugger ...
    (microsoft.public.de.sqlserver)
  • Re: loading sql files from a master file Oracle equivalent
    ... In Query Analyzer, no. ... In the command-line tool OSQL, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • SQL Server 2005 Express
    ... I've installed VS.NET 2005 Beta along with SQL Server 2005 Express Beta on ... I'm interested in connecting to SQL Server via query ... analyzer or a similar tool. ...
    (microsoft.public.sqlserver.server)
  • Re: multiple times execution of procedure
    ... If Query ... Analyzer told you that then it might not be accurate because it can't give ... server or what happened with the network link between SQL server and the ... concurrently and it executes that in an iteration M times. ...
    (microsoft.public.sqlserver.programming)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)