Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Script to check what was changed in database after 9PM Last night Expand / Collapse
Author
Message
Posted Thursday, January 7, 2010 7:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 15, 2011 10:48 AM
Points: 250, Visits: 55
Comments posted to this topic are about the item SQL Script to check what was changed in database after 9PM Last night
Post #843525
Posted Monday, January 18, 2010 12:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 14, 2014 11:49 PM
Points: 287, Visits: 407
I can't get this script to work on SQL server 2000, can you help? I get Invalid object name 'sys.objects'.
Post #848994
Posted Monday, January 18, 2010 2:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:25 AM
Points: 1,105, Visits: 4,902
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

If anbyone does know of something similar in SQL 2000 I would also be interested!
Post #849029
Posted Monday, January 18, 2010 2:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 14, 2014 11:49 PM
Points: 287, Visits: 407
thanks for letting me know, regarding upgrading the server unfortunatly it's not an option for me
Post #849033
Posted Monday, January 18, 2010 9:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:25 AM
Points: 1,105, Visits: 4,902
Nor me at present, but it's something to look forward to!
Post #849223
Posted Friday, February 5, 2010 10:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 10:42 AM
Points: 4, Visits: 400
I think this script detects index rebuilds, which you might not always want. how can those changes be omitted ?
Post #860680
Posted Wednesday, November 10, 2010 7:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 8:30 AM
Points: 94, Visits: 677
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.

Post #1018626
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse