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

Database table Change Expand / Collapse
Author
Message
Posted Tuesday, February 22, 2011 11:01 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, February 16, 2014 9:35 PM
Points: 98, Visits: 297
Please could someone help with the Immediate decision..

we have an application and there are 500/600 Users who access the application.

There are around 30 to 40 main tables exists for the application.
some tables have 5 million,some have 10 million and some tables have more then 40 million records....

my manager would like to know if any change happened in any of the row/column in any of the table...if yes then she wants to have the old record saved some where.....

for example: we have a Customer table...which has 40 columns in the table....
if any one of the column/row value has been changed by any user then i have to keep track of the old record...


Below are my Ideas...


I can write trigger on 30 to 40 tables...

but below are the problems...

It makes the application slow...and some records are updated by import process from the web services ...so they cannot
handle by the trigger....

i thought of mainting the history tables were i will be loading the records which been updated daily...but some of the tables do not have the modified date...so i do not know what record has been updated in that table....and if i keep on inserting the records into the history tables...then the table might keep on increasing the volume...


In the meeting team had couple ideas...they want to remove the update button on all the modules on the application...
and to remove the web services option for the users ...which will not have the update option ...If the user wants to update anything on the application..they will not be able tooo...they can only add new records...

But they did asked me instead of removing the update option on all the modules on the application...Is there any other way
that i can do from database side...that i can keep track of any column/row changes in any of the table in that database...


Could someone please help me with some suggestions...i have to update the team as soon as possible...

Post #1067763
Posted Tuesday, February 22, 2011 11:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:58 AM
Points: 13,872, Visits: 9,600
Please don't double-post.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1067765
Posted Tuesday, February 22, 2011 11:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, February 16, 2014 9:35 PM
Points: 98, Visits: 297
I am sorry...

I was confused and posted at both places....
Post #1067772
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse