Getting the metadata about a Query and a Stored procedure in SQL Server
SET FMTONLY ON can be used to return just column information, no rows will be processed or returned.


  Returns only metadata to the client. Can be used to test the format of
  the response without actually running the query. (BOL)