Procedure sp_recompile

  • Hi,

    Please someone advice me on this.

    SQLServer 2000

    ----------------

    Server: Msg 15009, Level 16, State 1, Procedure sp_recompile, Line 18

    The object 'function1' does not exist in database 'database1.

    The 'function1' exists in database 'database1' when I checked.

    Thanks and Regards,

    Ravi.

  • Ravi

    I take it function1 is a function? sp_recompile only acts on stored procedures and triggers.

    John

  • Functions cannot be recompiled, because their plans are not cached.

    The statements that call the functions can get cached, but not the function's plan itself.

    -- Gianluca Sartori

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply