Error 910 when running Stored Procedure 1

[gussifinknottle]

When I run the following stored procedure I get the error message displayed below. What am I doing wrong?

MY STORED PROCEDURE IS :
GetAssetTaxCal 3 , '1035' , 49 , 1 , '15 Oct 1996' , '15 Feb 2001' , 0 , 0

Output: NoOfResultRows:1 NoOfComputeRows:0

ERROR MESSAGE:
SQL Error:910: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate a new object descriptor for required system catalog in database '7'. Another database must be closed or objects in another database dropped in order to open this database.

 

[tlbroadbent]

It appears that you are running SQL Server 6.5. You'll need to increase the max number of databases or objects allowed to be open. Use SEM or sp_configure to set the values higher. You'll need to restart SQL Server.

Examples:
sp_configure 'open databases',100
sp_configure 'open objects',10000 Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost