title: SQL Server: Maximum number of records to return
body: <p>We have <code>RowCount</code> to set number of records to return or affect. But we need to set this each time before executing sql statement. I am looking a way to set this once my application started and so it affect all queries execute via my application. </p>
  
  <p><strong>Update</strong></p>
  
  <p>I want to achieve a trial version strategy with limited records! I don't want to mess with my actual code and wish somehow database restrict number of records return in result of any query! An alternative could be pass a parameter to each store-procedure but I really don't like this one and looking for some other strategy!</p>