Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

Sp_recompile forces all triggers and stored procedures to recompile the next time the table is accessed

sp_recompile tablename   GO