SQL Server Query Size of Results Set

Is there anyway in SQL Server to determine the size in MEGS of dat开发者_运维技巧a that a query returned in a query from Mgmt Studio in the Result Set?

---

You can turn on client statistics (Query menu, Include Client Statistics) which gives number of bytes returned from the server when the query is executed.

---

Create a table with query results and run sp_spaceused against it.

SELECT *
INTO tablename
FROM ...

Exec sp_spaceused 'tablename'

DROP TABLE tablename