Post reply

suppress display of result set

  • January 29, 2009 at 8:36 am

    #127697

    Is there a way to suppress the display of result sets? I am performing a loop that does a number of select statements. I would prefer that the result sets not display. Of course, I am hitting the warning: "The query has exceeded the maximum number of result sets that can be displayed in the results grid."

  • January 29, 2009 at 11:31 am

    #934935

    Change result set mode to text.

    🙂

  • January 29, 2009 at 12:17 pm

    #934979

    dglane

    Is there a way to suppress the display of result sets?

    vishal.gamji

    Change result set mode to text

    Changing to text output willl not suppres the display of result sets.

    You can direct the results to a file - they will not be displayed in the SSMS window but they will be saved in the in the file you name (file extension is by default .rpt) What will be displayed in the SSMS results window is the count of the number of rows effected. and if you later want to review the results you can open the file in which the results were saved.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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