Post reply

change results target using t-sql code

  • May 27, 2008 at 1:53 pm

    #75222

    is it possible to change the default settings in query analyzer under tools/Options/Results Tab to the following using T-sql code in an sp to get these results for that sp?

    Results Target = "Results to File"

    Output format = "Tab Delimited"

    Max Char = "8192"

    Print column headers = checked

  • May 27, 2008 at 1:57 pm

    #820809

    What exactly are you trying to do? Why do you want the SP to get the results this way?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • May 27, 2008 at 2:03 pm

    #820813

    i "inherited" a monthly process of running this sp to spit out to a .txt file for a dept to do whatever it is their doing with it. This process has to run late in the evenings and I'd like to automate the task instead of doing the steps of changing these options and executing the sp by hand. I cannot use bcp because the sp is using temp tables.

  • May 27, 2008 at 11:52 pm

    #820982

    Check out "isql utility" article in BOL.

    _____________
    Code for TallyGenerator

Viewing 4 posts - 1 through 4 (of 4 total)

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