I have written a stored procedure that returns a couple of columns of data. This stored procedure is normally executed from my application and the returned information is important.
However I need to run it once on my table for each row (+400000) from Management Studio. I have tried to do this but the returned columns are displayed in the results pane each time the stored procedure is called. Eventually Managment Studio crashes because of the large amount of data in the result pane.
Is there any way to execute a stored procedure and direct the output away from the results pane? i.e. hide it or send it somewhere like a black hole?