Customer stories Events & webinars Ebooks & reports Business insights GitHub Skills ...

sp_recompile looks for an object in the current database only. The queries used by stored procedures, or triggers, and user-defined functions are optimized only when they're compiled.