Re: Query Analyser - output SQL commands to Results pane

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

As far as I am aware, there is no such capability.

You could copy the SQL command and put it in a Print statement just before
the execution.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Johnny Williams" <REMOVEjohnwilliams_esq@xxxxxxxxxxxxxx> wrote in message
news:ei8j8c$8tk$1@xxxxxxxxxxxxxxxxxxxxxxxx
With Query Analyser for SQL Server 2000, when I open a .SQL script and
execute it, the 'Messages' tab of the Results pane contains the results of
executing the script, including any errors. How do configure QA or
otherwise (e.g. by a command in the script), so that the each SQL command
is also output to the Results pane before the result of that command?

This would make it far easier to see debug scripts and determine
immediately which statement caused an error.

Thanks for any help.



.

Relevant Pages

  • Re: Importing functions that require parameters
    ... As a python module is executed when ... To prohibit execution ... Now the print statement will be executed if you invoke your script from ...
    (comp.lang.python)
  • Re: scripting an object
    ... You can reference from within VC++ to object library DMO/SMO and script ... We use VC++ and OLEDB to access MS SQL Server databases. ... during change its type (to nvarchar, nchar with 'ALTER TABLE table name ... There is exist tranact SQL command, stored procedure to get an object ...
    (microsoft.public.sqlserver.programming)
  • Re: MySQL client ran out of memory
    ... mentioned error message. ... The script works perfectly fine on a pilot ... If I just run the sql command from the mysql client with the --quick ...
    (perl.dbi.users)
  • Re: Query Analyser - output SQL commands to Results pane
    ... How do people debug SQL scripts then? ... You could copy the SQL command and put it in a Print statement just before ... of executing the script, including any errors. ...
    (microsoft.public.sqlserver.tools)
  • [Info-ingres] FW: [Users] How to Log errors while executing ingres sql command
    ... How to Log errors while executing ingres sql command ... use awk, like e.g.: ... The /tmp/x script looks like ... For this I am trying to create regular expression which wll grep error ...
    (comp.databases.ingres)