Failed to get the call stack! error

I'm working with a team on a migration of a database from Sybase to SQL
Server 2000.
Currently I'm in the process of debugging a sequence of stored procedure
calls wich are relatively long and nested.
In the process of returning from the stored procedures, after the job done
in the lowest level of calls (within transactions) , I get the message:
Server: Msg 3701, Level 11, State 5, Procedure PCRMQDD00vInt, Line 771
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table
'#TRMCQDL0', because it does not exist in the system catalog.
Failed to get the call stack!
the temporary table was created at that stored procedure before some
subsequent calls. I just want to make sure I got the message right. Does thi
s
message mean the processe run out of memory? Is there a way to parametrize
the use of more memory or we need more RAM ?
thanks in advance
Jo?o CostaHi
You may be seeing this sort of issue (although this KB talks about 6.5!)
http://support.microsoft.com/defaul...kb;en-us;157570
http://support.microsoft.com/defaul...kb;en-us;827448
You may want to look at blocking [url]http://support.microsoft.com/kb/271509/EN-US/[/ur
l]
and possibly reducing the number of temporary tables you are using (possibly
using derived tables!)
John
"Jo?o Costa" wrote:

> I'm working with a team on a migration of a database from Sybase to SQL
> Server 2000.
> Currently I'm in the process of debugging a sequence of stored procedure
> calls wich are relatively long and nested.
> In the process of returning from the stored procedures, after the job done
> in the lowest level of calls (within transactions) , I get the message:
> Server: Msg 3701, Level 11, State 5, Procedure PCRMQDD00vInt, Line 771
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table
> '#TRMCQDL0', because it does not exist in the system catalog.
> Failed to get the call stack!
>
> the temporary table was created at that stored procedure before some
> subsequent calls. I just want to make sure I got the message right. Does t
his
> message mean the processe run out of memory? Is there a way to parametrize
> the use of more memory or we need more RAM ?
> thanks in advance
> Jo?o Costa