Click here to Skip to main content
Rate this: bad
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 19:53pm
Sergey Alexandrovich Kryukov at 4-Oct-12 1:01am
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 at 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 at 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 at 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)

Advertise | Privacy | Mobile
Web02 | 2.8.150129.1 | Last Updated 25 Nov 2012
Copyright © CodeProject, 1999-2015
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