MS SQL Compiling a Stored Procedure With a Requery

173 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 List of All Views in MS SQL Database

Disadvantages of Using Stored Procedures in MS SQL

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...

Making a Backup of MS SQL Database With Query

What is Log Shipping in SQL Server ?