How to see modified SP's in Database :
For SQL Server 2005 and 2008
SELECT
[name]
,create_date
,modify_date
FROM
sys.objects
order by modify_date Desc
For SQL Server 2000
SELECT
[name]
,create_date
,modify_date
FROM
sysobjects
order by modify_date Desc
For SQL Server 2005 and 2008
SELECT
[name]
,create_date
,modify_date
FROM
sys.objects
order by modify_date Desc
For SQL Server 2000
SELECT
[name]
,create_date
,modify_date
FROM
sysobjects
order by modify_date Desc
No comments:
Post a Comment