SQL Script to check what was changed in database after 9PM Last night
-
Comments posted to this topic are about the item SQL Script to check what was changed in database after 9PM Last night
-
I can't get this script to work on SQL server 2000, can you help? I get Invalid object name 'sys.objects'.
-
In SQL 2000 you'd use SYSOBJECTS; unfortunately the fields in the query aren't avialable in SQL 2000 so you'll need to wait until you've upgraded :sick:
If anbyone does know of something similar in SQL 2000 I would also be interested!
-
thanks for letting me know, regarding upgrading the server unfortunatly it's not an option for me
-
Nor me at present, but it's something to look forward to!
-
I think this script detects index rebuilds, which you might not always want. how can those changes be omitted ?
-
I think that Gary McGibbon might be onto something.
I ran the stored procedure against my production database, and it literally returned every user table in the database with sequential modify_date entries. It looks to me like either the nightly backup process, or the nightly UPDATE STATISTICS & REBUILD INDEX job caused it to return every table as being modified.
-
Thanks for the script.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply