-
Finding Modified Objects
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.
-
Schema_ver
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|