Search This Blog

Monday, February 11, 2013

How can find out all modify Store Procedure in your database by query?


How can find out all modify Store Procedure in your database by query?

SELECT name,modify_date,*

FROM sys.objects

WHERE type = 'P'

AND DATEDIFF(D,modify_date, GETDATE()) < 1

No comments :