sp_recompile forces all triggers and stored procedures to recompile the next time the table is accessed. : sp_recompile « System Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Functions
  3. sp_recompile
sp_recompile tablename  
GO
25.51.sp_recompile
25.51.1.sp_recompile forces all triggers and stored procedures to recompile the next time the table is accessed.
25.51.2.Example of Using sp_recompile