Post reply

Redirect Message Output

  • March 11, 2004 at 4:51 pm

    #84247

    Is there any way to redirect all of the output information that normally displays in Query Analyzers messages window?

    I have several queries and stored procedures that being able to write this information to a file would be of HUGE benefit.

    Thanks

     

    Tom

  • March 11, 2004 at 5:31 pm

    #498417

    In Query Analyzer, click tools/options/results

    You have option to save result to file.

  • March 11, 2004 at 5:57 pm

    #498420

    I probably did not explain myself very well, Sorry.

    I just want to get the same kind of information that normally shows up as a message in Query analyzer but I will not be running Query Analyzer. I want to schedule a job that runs in the middle of the night without assistance and does not use query analyzer.

     

    Thanks for your reply

     

    Tom

     

     

  • March 12, 2004 at 12:34 am

    #498441

    If you're talking about scheduling the job...

    If you use SQL Agent Job Scheduler, when you add a step to the job, on the advanced tab there is an option to specify the log file. This should do the trick for you.

    Regards,

     

    Greg M Lucas
    "Your mind is like a parachute, it has to be open to work" - Frank Zappa

  • March 15, 2004 at 8:27 am

    #498779

    You can also use the command-line version, OSQL, and specify an output file using the "-o" option.  Note that you may need the "-w" option to specify a line-width greater than 255.  Look in BOL under "osql utility."

     

  • May 10, 2004 at 1:26 pm

    #505865

    i can´t imagine how can i do that on 6.5 version...  

  • May 10, 2004 at 1:58 pm

    #505870

    Look at isql for version 6.5.

  • June 7, 2004 at 2:42 pm

    #509327

    I can do it running a batch with this string:

    isql -S server -U sa -P password -d userdatabase -Q "exec SP" -o salida.txt

     

    Late answer, but who knows...maybe still could help

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply