Click here to Skip to main content
13,002,628 members (62,682 online)
Rate this:
Please Sign up or sign in to vote.
Can someone tell me what the best solution is for creating logging system (Audit trail) !? I'm using with MSSQL 2005

Your help would be greatly appreciated
Thanks in advance
Posted 3-Oct-12 18:53pm
You are asking for the "best", but limit the expert to certain software of certain version. How can you demand the best then? And who is going to define the predicate "better"? Are you getting the idea?
sali22 4-Oct-12 3:47am
let me change my question ,, is it a good idea to use this logging in database level or we must control it in programming level ! ?
DaveAuld 4-Oct-12 4:36am
Answer this; What if someone modifies the data directly in the Database without using your app, how you going to audit that?
sali22 4-Oct-12 4:50am
you are absolutely right ,, tq

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

you have to use the both ways

logging in database and logging system in your application

you can create a table in the database to add actions in your application

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170626.1 | Last Updated 25 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100