Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Procedure sp_recompile Expand / Collapse
Author
Message
Posted Tuesday, March 6, 2012 4:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 6:30 AM
Points: 250, Visits: 743
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.
Post #1262046
Posted Tuesday, March 6, 2012 4:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:54 AM
Points: 5,369, Visits: 9,894
Ravi

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

John
Post #1262051
Posted Tuesday, March 6, 2012 4:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:03 AM
Points: 5,019, Visits: 10,559
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

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1262052
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse