Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    5

    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

    Line 1:

    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.

    What can I do with this?

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: There is not enough procedure cache to run this procedure

    Increase your procedure cache OR decrease the size of your procedure.

    On ASE 12.5 => sp_configure "procedure cache size", n (default n=3271)

    Before ASE 12.5
    sp_configure "procedure cache percent", 25 (default is 20; it's the percent of the total free cache)

  3. #3
    Join Date
    Oct 2003
    Posts
    706

    Lightbulb

    At first I thought you were somehow doing something recursive. But anyway, howcum you're using "=" operators when you could be using JOIN here?
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  4. #4
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Originally posted by sundialsvcs
    At first I thought you were somehow doing something recursive. But anyway, howcum you're using "=" operators when you could be using JOIN here?
    We've no garantee about the version used by Abat. Pre-12 doesn't accept ANSI JOINS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •