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

Answers

Chelo,

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,

Eric

-- Anonymous, March 14, 2000