In my databases I have some Stored procedure with recompile
The way I find them is:
SELECT OBJECT_NAME(ID)AS SP_NAME,* FROM SYSCOMMENTS WHERE TEXT LIKE '%WITH RECOMPILE%'
when I look at:
select * from sys.procedures
I find no indication of recompiles.
Is there a better or more elegant way to find the with recompile stored procedures?