is there a way to display the size in bytes of the results from a query
in management studio?

Not sure if it's quite what you're after but if you select the "Include
Client Statistics" button in Management Studio (generally it's the one to
the left of the exclamation mark for SQLCMD mode) then you'll get an
additional tab in your results for Client Statistics and one of the result
rows in there is the "Bytes received from server"

Show quoteHide quote

Upgrade connection issues
View results of Dynamic SQL in Management Studio
SQL 2005 Management Studio can't edit text rows with > 4000 charac
backup again
SQL 2205, Profiler and Deadlocks