I am currently writing triggers to track changes in each column of each table of a database. It creater 2 audit tables: one with general info (userID, time, etc.) and other has details (oldvalue, newvalue, etc.)
How do you normally keep track of binary value change (old/new values for image for example)? Convert and save first 80 chars? Doesn't make much sense..
Just curious what are other practices on that.
Thanks,
Sabina
SQL Server - binary column value change
-
- Уже с Приветом
- Posts: 5669
- Joined: 13 Oct 2000 09:01
- Location: East Bay, CA
-
- Уже с Приветом
- Posts: 5669
- Joined: 13 Oct 2000 09:01
- Location: East Bay, CA
Re: SQL Server - binary column value change
Sorry, "vopros snyat."
References to text or image columns in either the inserted or deleted tables appeared as NULL.
References to text or image columns in either the inserted or deleted tables appeared as NULL.