SQL Server - binary column value change

User avatar
Sabina
Уже с Приветом
Posts: 5669
Joined: 13 Oct 2000 09:01
Location: East Bay, CA

SQL Server - binary column value change

Post by Sabina »

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
User avatar
Sabina
Уже с Приветом
Posts: 5669
Joined: 13 Oct 2000 09:01
Location: East Bay, CA

Re: SQL Server - binary column value change

Post by Sabina »

Sorry, "vopros snyat."

References to text or image columns in either the inserted or deleted tables appeared as NULL.

Return to “Вопросы и новости IT”