|
Home > Archive > MS SQL Server > May 2005 > Using Triggers to Create an Audit - Newbie.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Using Triggers to Create an Audit - Newbie.
|
|
|
| Hi all,
haven't done much at all out of the ordinary for SQL , but am hoping someone
can show me how to achieve this. What I want to do is create an exact
replica of our main table to log any records that are added/edited/deleted
and which windows user/computer did this. I am using SQL server
authentication.
Can someone show me a useful tutorial on how to do this ? I'd really
appreciate it.
cheers,
Adam
| |
| Sue Hoegemeier 2005-05-18, 3:23 am |
| This is a good article for walking through the process:
http://www.aspfaq.com/show.asp?id=2448
-Sue
On Wed, 18 May 2005 10:35:01 +1000, "acs68"
< adamst@NOSPAMlaidley
.qld.gov.au> wrote:
>Hi all,
>
>haven't done much at all out of the ordinary for SQL , but am hoping someone
>can show me how to achieve this. What I want to do is create an exact
>replica of our main table to log any records that are added/edited/deleted
>and which windows user/computer did this. I am using SQL server
>authentication.
>
>Can someone show me a useful tutorial on how to do this ? I'd really
>appreciate it.
>
>cheers,
>
>Adam
>
|
|
|
|
|