title: Getting the ROWCOUNT value (not @@ROWCOUNT) in SQL
body: <p>Is there a way to see what ROWCOUNT is set to?  </p>
  
  <p>The component that is used to call my stored procedure has an option to limit how many rows are returned, but it apparently does that by setting ROWCOUNT.  One stored procedure only returns a single aggregated row, but the intermediate queries sometimes return more than the limit and are getting truncated.  The function that does all of this is generic and is used to call other stored procedures; some my other procedures may need the limit.</p>
  
  <p>Right now I am setting ROWCOUNT to a very large number at the top of my stored procedure and then setting it back to the (hard-coded) regular limit before I return my result.  I don't maintain the component that calls my stored procedures so I may not know if the returned row limit is changed.  What I'd like to do is set a local variable to the current ROWCOUNT value, and then set it back at the end.  Is there any way to actually see what ROWCOUNT is set to?</p>