• 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.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices