Unanswered: There is not enough procedure cache to run this procedure
select count(*) from service ser, servicecategory sercat, category cat, categorychildren cch where upper(ser.name) like '%CAR%' and ser.serviceid=sercat.serviceid and sercat.categoryid=cat.categoryid and cat.categoryid=cch.childcategoryid and cch.parentcategoryid=28 order by sercat.serviceordernum
Server Message: Number 701, Severity 17
There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure SQL Server with more procedure cache.