I'm using a sp in SQL Server 7.0 to return a recordset. My problem is that I had to set NOCOUNT on so that the ordinal reference would work when assigning the values returned from the recordset to my variables. However, I need to count the records in my ASP. Since NOCOUNT is set to ON in my sp, I always get -1 when using record.count. Is there an easy way to overcome this? I dread the idea of having to call a separate sp just to test the record count. Thanks.