Does anyone know the system tables I need to query to produce a report of stored procedures (SQL 2005) that had any changes made to them in a user-specified date range?
In SQL 2005, I saw the canned database reports, but this one didn't exist. Any help would be greatly appreciated.
Thanks!
Wow, already off the first page so quickly?
Sorry for the bump, I just wanted to be sure there was no quick answer to this. I would have thought it would be an easy thing to do, I may be mistaken.
Any takers?
Thanks again.
You can get any object now using the sys.objects view. For sprocs, you'd want something like this:
Code Snippet
select * from sys.objects where type='P' and modify_date between getdate() - 1000 and getdate()-Jessica
|||Perfect! I knew it must be something simple I was missing.
Thanks, Jessica!
