The script is not work when the Stored Procedure are in a specific schema.

USE [DatabaseName] EXEC sp_recompile [Schema.Storedprocedure]

INSERT INTO @TblTable

(

DBName

, RecompileStmt

)

VALUES

(

@name

, N'Select N'...

Hello,

I have executed your script on my sql server. I had a lot of error because it is case sensitive .

I corrected the mistakes and fontionne well, I think I...