It's up to you. However, an audit trail is nothing more than recording all transactions (Insert/Update/Delete) performed on the table.

>Thanks! Bud we must write this by ourselfs. We do not realy need an audit trail. Bud we need to protocoll each Insert/Update/Delete in our specific Table. Thats why i asked!
>
>>Take a look at You can aslo consider using commercial product SQLAudit from http://www.redmatrix.com/default.asp?section=sqlaudit
>>
>>
>>>Hi Kevin!
>>>
>>>do you now have a solution for your Problem? We are looking for the same. If you can give me some tips, i would be pleased.
>>>
>>>thanks
>>>
>>>Jörg Schneider
>>>B&R (Germany)
>>>