>I am creating some cursors on a SQL-Server, so with the SQL Pass through, there is no record set returned to VFP.
>
>At present, after creating the cursor, I issue a
> select count(*) from table
>
>which I do have the results returned to VFP to determine the number of records created. Is there some stored procedure that will just return this number from some system table??? It takes quite a while especially on tables of 500,000 or more records.
>
>TIA

You can run the sp_spaceused passing a table name, this will return the number of rows in the table.

BOb