Re: Trigger to get log file transaction into a table.
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Thu, 21 Aug 2008 08:23:50 +0300
What version are you using? SQL Server 2008has something similar
"Hoardling1 via SQLMonster.com" <u43783@uwe> wrote in message
news:88f5a5f9ef55e@xxxxxx
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
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-security/200808/1
.
- Follow-Ups:
- Re: Trigger to get log file transaction into a table.
- From: Hoardling1 via SQLMonster.com
- Re: Trigger to get log file transaction into a table.
- Prev by Date: Re: Integrate AzMan with SQL Database?
- Next by Date: Re: Trigger to get log file transaction into a table.
- Previous by thread: Integrate AzMan with SQL Database?
- Next by thread: Re: Trigger to get log file transaction into a table.
- Index(es):
Relevant Pages
|
