history for sys.all_objects

[Bell1991]

I am attempting to find out when a stored procedure was altered. The table sys.all_objects has the last time it was modified - but is there another table that keeps a history of the changes (just date - not actually changes)?

Thanks in advance!

 

[JayKusch]

SQL Server does not have a change control methodology or history schema.

Thanks

J. Kusch

 

[mrdenny]

The last time the procedure was modified would be the last time it was altered via the ALTER PROCEDURE command.

SQL 2005+ only tracks the most recent timestamp.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[mutley1]

As MrDenny said - only 2005 will track this. If you have 2005 then something good to look at is DDL triggers. If you set them up correctly they can record changes to objects such as databases, tables, SP's etc.

Very handy.

M.