how to check the size of data retrieved using a stored procedure

Question

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

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

vinu512 SSCoach Points: 15729 More actions · Answer 1

You can turn on CLIENT STATISTICS which gives the number of bytes returned from the server when a Query/Procedure is executed.

The next best thing to this would be to get the ResultSet into a table and Execute sp_spaceused on that table.

Vinu Vijayan

For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉