Post reply

SSMS output to txt . . . where does SSMS put the output file?

  • August 20, 2019 at 9:55 pm

    #3672941

    I ran a report, outputting to TXT, but where does SSMS put the output file?

     

    thanks

  • August 20, 2019 at 10:10 pm

    #3672946

    You mean 'Results to File'?

    You will be prompted for a file name/location when you execute the query.

    Results to Text puts the results into the Results pane, in text format.

    • This reply was modified 5 years, 3 months ago by  Phil Parkin.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • August 20, 2019 at 10:12 pm

    #3672948

    i executed several reports, none prompted me . . .

    i went to

    Tools/options/SQL Server/Results to text

    selected my options and said ok....

     

    did i miss something??

     

    thanks

  • August 20, 2019 at 10:14 pm

    #3672949

    jeffshelix wrote:

    did i miss something??

    Did you even read my response?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • August 20, 2019 at 10:16 pm

    #3672951

    Yes I did. Did you read mine?

    thanks

     

  • August 20, 2019 at 10:21 pm

    #3672952

    Indeed I did. I believe that yours demonstrates that you did not read mine.

    Why are you persisting with Results to Text after I told you (implicitly) that this does not even create a file?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • August 20, 2019 at 10:22 pm

    #3672953

    There is a default location you set in the same area where you went to Tools...Options and results to Text. On the General section under default destination for results. Below that is Default Location for Saving Query Results.

    Sue

  • August 21, 2019 at 12:34 pm

    #3673095

    So, we're talking at cross purposes here.

    Results to text put the results out as text in the results window. They don't go to any file anywhere. They're just text instead of a grid. Results to file goes out to a file as outlined by the others already.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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