MS SQL Compiling a Stored Procedure With a Requery

45 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 System Hard Disks with Free Space in MS SQL Serve ...

What are Wait Types in SQL Server ?

What are Table Valued Parameters ?

How is Change Tracking is Different From Change Data Capture ?

How is Deadlock Different From a Blocking Situation in SQL Server ...