MS SQL Compiling a Stored Procedure With a Requery

207 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

MS SQL Restoring a Database With a Query

How to Learn MS SQL Server Version

Adding Columns to a Table with a Query in MS SQL

Creating a View in MS SQL

How to Rebuild the Master Database in SQL Server ?