Sys objects - Modify date

Sys objects - Modify date

Post by Helen Stei » Thu, 20 Oct 2005 06:47:26


Hello,

Is there any way to determine the date when a database object (SQL Server
2000) was modified?
Example: a column was added to a table.
Some code was changed in SP or UDF.
Create Date reflects only when an object was created.

Thank you,
Helen
 
 
 

Sys objects - Modify date

Post by Jerry Spiv » Thu, 20 Oct 2005 07:22:17

Helen,

You would have to had Profiler or some third-party auditing tool to
determine that. Optionally you could use a third-party transaction log
viewing tool i.e., Lumigent Log Explorer.

HTH

Jerry