Procedure sp_recompile

• ravisamigo

  SSCertifiable

  Points: 7440

  More actions

  March 6, 2012 at 4:09 am

  #269431

  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.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  March 6, 2012 at 4:23 am

  #1455184

  Ravi

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

  John

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  March 6, 2012 at 4:23 am

  #1455185

  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