Returning a recordset from a stored proc

Hello everyone,

I use stored procedures most of the time for returning data from our
database. Our latest SP is a script of around 5000 lines and this executes
okay from the database, but a call from an asp page fails at the open
recordset line. All the other sp's return data to the asp pages without
problems so its not a connection problem nor is the sp failing.

I'm just wondering if this problem has to do with the size of the sp. Any
help or advise will be much appreciated.

Thanks,
Andrew.

I use the standard UD call for the recordset.

<!--#include file="../../Connections/XcapeSQL.asp" -->
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_XcapeSQL_STRING
Recordset1.Source = "{call dbo.GetRoomOptions}"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>