MS SQL Compiling a Stored Procedure With a Requery

88 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

Using MS SQL Order By

What is Blocking in SQL Server ?

How to Restart SQL Server in Single-User Mode ?

Getting List of All Stored Procedures in Database in MS SQL

What Have INCLUDED Columns With SQL Server Indexes ?