Problem with recordset

Hello everyone,

I have a stored procedure that works fine within the database. It has no
input variables so I should be able to just call it from an asp page. It
does however take a few seconds to execute when testing within the database.

My problem is that it returns an empty (no) recordset when testing (pressing
the test button). I find this really odd as I use sp's all the time, but
maybe its got to do with the way the stored procedure delivers its result
set.

If anyone has any suggestions please let me know.

Thanks,
Andrew.