Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-29 : 09:34:10
|
Piyush writes "Hi
I am working on a site which is based on 3 Tier architecture. Im middle tier we are using VB for making components and in backend we r using SQL Server 7.0. Our requirement is to track all the endorsements made at feld levels for each table, let us say if i made any change to -5 columns of one table i want to make the transaction log ( we r using one table for this) with the old values and new values. What we think is to compare each and every field and then update the transaction log table according to that but i think this is not an efficient way is there any way to track the changes while updating and at the same time updating the transaction log table. Is there any way in SQl server or more efficient way in front end to materialise this issue..
Rgds" |
|
|
|
|
|
Maintaining Transaction Log