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: Monday, November 10, 2014 8:16 PM
Points: 250, Visits: 751
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: Friday, October 31, 2014 11:06 AM
Points: 5,430, Visits: 10,108
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 3:03 PM
Points: 4,608, Visits: 11,002
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

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1262052
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse