Hi All,

I'm looking for the solution to a problem that I come up against. I need 
to open a recordset with a static cursor using a Stored Procedure in SQL 
Server. Using the ADO command object to append the parameters and then 
returning the recordset in ASP works fine, but you can only return a 
recordset with a read only lock and a forward only cursor.

Is there a way to execute a SPROC using ASP and ADO that returns a 
recordset with a static cursor?

If not ideas on the best other alternative would be helpful.

Thanks and best regards,
Jules.