Pages

Sunday 17 February 2013

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:

Post a Comment