Last update of objects : LUSENET : SQL Server Database Administration : One Thread

Eric, Is there a way for me to find out through the system tables (or wherever) the date when a particular object was last altered?

Thanks, Chelo

-- Anonymous, March 14, 2000



Not really. For performance reasons SQL Server does not track this information. You could set up a separate table to track this and use triggers to update the table.

In the sysobjects table, SQL server tracks when the schema is changed in the crdate column.

Hope this helps,


-- Anonymous, March 14, 2000

Moderation questions? read the FAQ