hi,
I want to find the modified database objects(Tables, Proc and Fun) in last 3 days in SQL 2000.
With Regards
Praveen (DBA)
Printable View
hi,
I want to find the modified database objects(Tables, Proc and Fun) in last 3 days in SQL 2000.
With Regards
Praveen (DBA)
You have to set up triggers, etc., to monitor the objects, or use a log viewer to look through the database logs for the past 3 days.
SQL Server does not capture update date for an object. If something new is created then you can check crdate column in sysobjects.
Other thing you can do is monitor schema_version in sysobjects. It changes every time an object is modified, but to find out what changed in three days, you need to get schema_version three days old.
hi,
Thanks about this info (schema_ver), I didn't no that...
With Regards
Praveen(DBA)
This value doesn't apply to sp nor udf.