How to List All table Modified, altered, updated, inserted in sqlserver 2000 database Last N Days.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » How to List All table Modified, altered,...

How to List All table Modified, altered, updated, inserted in sqlserver 2000 database Last N Days.

Rate Topic

Display Mode

Topic Options

Author

Message

Pritam Salvi

Posted Tuesday, October 26, 2010 3:49 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 26, 2010 9:38 PM
Points: 102, Visits: 53

How to List All table Modified, altered, updated, inserted in sqlserver 2000 database Last N Days.

I have two databases which is Thomasnet_N other one one Thomasnet_New

I want to find out which is recently updated which one i want to use for live testing.

Regards,

Pritam Salvi
SQL DBA
Mumbai. India[size="7"][/size]

Post #1010634

Pritam Salvi

Posted Wednesday, October 27, 2010 2:46 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 26, 2010 9:38 PM
Points: 102, Visits: 53

I have this query to find out created table in last N days.

Select name, id, crdate
From sysobjects
Where type ='U'
and DateDiff(D,refdate,getdate()) < 7;

But it will get last created, I want last modified or insert/updated table.

Is there any idea?

Regards,

Pritam Salvi
SQL DBA
Mumbai. India[size="7"][/size]

Post #1011338

steveb.

Posted Wednesday, October 27, 2010 3:36 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:42 AM
Points: 2,802, Visits: 7,103

you wont be able to get that information by default sorry, you can build this functionality in with triggers however this will only help for the future.

Post #1011351

Pritam Salvi

Posted Wednesday, October 27, 2010 3:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 26, 2010 9:38 PM
Points: 102, Visits: 53

Thanks for reply Steveb.

Regards,

Pritam Salvi
SQL DBA
Mumbai. India[size="7"][/size]

Post #1011356

GilaMonster

Posted Wednesday, October 27, 2010 4:10 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

You'll need a trace to get the DDL (schema) changes as SQL 2000 has no DDL triggers.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1011369

Pritam Salvi

Posted Wednesday, October 27, 2010 4:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 26, 2010 9:38 PM
Points: 102, Visits: 53

Thanks Gail.

Regards,

Pritam Salvi
SQL DBA
Mumbai. India[size="7"][/size]

Post #1011377

« Prev Topic | Next Topic »

Permissions