MS SQL Compiling a Stored Procedure With a Requery

205 Reads Ms Sql

The following query model is run to recompile the stored procedure in MS SQL with the query.

EXEC sp_recompile '{Our SP Name}'

Here is an example of usage..

EXEC sp_recompile 'SP_UPDATE_CONTACTS'
Ms Sql

You May Interest

Getting Rows in a Table in Random Order in MS SQL

How to Show Line Numbers in MS SQL Server ?

What is Partial Cache Mode in SSIS ?

MS SQL Getting List of All Column Names of a Table

What is SQL Server Agent ?