title: How can you tell if a Sql Server Stored Procedure returns records
body: <p>Within tsql I'm calling a tsql stored procedure that returns a record set. I want to be able to tell if the record set is empty or not empty. </p>
  
  <p>For some reason @@rowcount always returns 1. </p>
  
  <p>What is the best way to do this? </p>
  
  <p>One more thing I'm not in a position to edit this stored procedure. </p>