• Jason-299789 (9/24/2012)


    Phil,

    what about using the Results to File option in SSMS, its a bit cumbersome but should will allow the results to be stored.

    Also switch on "Include the Query in the Result set" for Results to Text under Tools->Options->Query Results->SQL Server.

    hope this helps.

    Thanks for the response Jason.

    That would be workable if it were not for the fact that there does not seem to be an option to append in the 'Messages' pane - instead it is cleared for every batch of instructions executed.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.