Could not allocate a new object descriptor

[rajeevnandanmishra]

Hi

I am running a procedure on my SQL 6.5 server (service pack 5). It is having a loop to run 1500 times. I am constantly getting following error message:
-----------
Server: Msg 910, Level 17, State 7, Procedure matsitelog_trig, Line 28
Could not allocate a new object descriptor for required system catalog in database '2'.
Another database must be closed or objects in another database dropped in order to open this database.
-----------

Moreover, while i was printing the information in loop, i am getting the above error just after the 1174th record is processed.

Any help is highly appreciated.
Thanks in advance.

Rajeev