When most of my users query my database, they are after a small number (1 - 500) of records. Occasionally, someone will run a query whose result is a recordset containing 100,000+ records.<BR><BR>Does SQL Server 7.0 provide a method that once a recordset grows beyond a certain number of records, the database "dumps" the recordset and kills the process/query?<BR><BR>Thanks in advance for your help.