Trigger to get log file transaction into a table.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hoardling1 - 20 Aug 2008 17:16 GMT

My scenario is: I have a subscriber database that does not change often,
except for transactional replication. I am presently tracking who, when and
what table is being changed from a trigger. What I would also like to do is
track what exactly is being changed. Now, I've thought about using the
inserted and deleted to get me the old and new, but I was wondering if I
could get the SQL statement from the log file on what has been changed. This
way I can keep exact details of what was changed.

Thanks

Reply to this Message

Uri Dimant - 21 Aug 2008 06:23 GMT

What version are you using? SQL Server 2008has something similar

> My scenario is: I have a subscriber database that does not change often,
> except for transactional replication. I am presently tracking who, when
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message

Hoardling1 - 21 Aug 2008 15:41 GMT

I am presently using 2000, but if you have information for 2005 and 2008 I
would also appreciate it because I will be transferring to those very soon.
Just right now it is for 2000.

>What version are you using? SQL Server 2008has something similar
>
[quoted text clipped - 3 lines]
>>
>> Thanks

Reply to this Message

Uri Dimant - 24 Aug 2008 08:14 GMT

Hi
http://www.databasejournal.com/features/mssql/article.php/3725476

>I am presently using 2000, but if you have information for 2005 and 2008 I
> would also appreciate it because I will be transferring to those very
[quoted text clipped - 9 lines]
>>>
>>> Thanks

Reply to this Message