I would like to know the following: 1. What t-sql can I use to see if a stored procedure has changed? I want to see the last modified date? Would I look at sysobjects? 2. What t-sql would I use to see if a view and function changed. I would like to see the last modified date? Would I look at sysview?
Hi you can use sys.object view in order to find out modify date of an object here is the query: SELECT * FROM sys.objects WHERE type IN ('FN', 'IF', 'TF','P','V') P means proc v mesan view and others mean functions.