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 - 2001-02-08 : 15:50:27
|
Geoff writes "I am implementing an audit strategy that requires making a copy of the old record into that tables audit copy when a record is updated. A problem arises when the record in question contains a text field.
Have you found a better solution to this problem than instead of updating the table directly, doing it via a stored procedure so that you can access the old data before applying the new?" |
|
|
|
|
|
Triggers, the inserted and deleted tables and text fields.