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 - 2005-07-07 : 06:15:15
|
| Jeff writes "Hello,My dilema is this; Our current transaction log will populate the event field with the entire table's information. For example, say a customer's phone number is changed. The log currently will contain; Customer name, address, phone number, contact name, geographic location, billing status, service type, etc etc....Is there a way to just have what was changed populate the log?That is, if the phone number is changed, the log will say "USERNAME: Changed customer phone number to 123-4567"Any help is GREATLY appreciated.Thank you,Jeff" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-07-07 : 06:48:50
|
| how do you populate the transaction log? post the codeif this is a trigger and not from an application, you can explore update(), columns_updated()if from application, modify the way the logging works?--------------------keeping it simple... |
 |
|
|
|
|
|
|
|
Trans Log Data