title: How to run a stored procedure report and then send the result into email?
body: <p>I am using SQL Server 2005. I have a report that is using stored procedure with just few lines of records and would like to send the whole recordset through an email and sets this into a schedule.</p>
  
  <p>This is only an interm solution BTW till we integrate this stored procedure into reporting service + .net app.</p>
  
  <p>I am appreciated your comment.</p>
  
  <p>Thanks</p>