Click here to Skip to main content
Rate this: bad
good
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 vb.net with MSSQL 2005
 
Your help would be greatly appreciated
Thanks in advance
Posted 3-Oct-12 18:53pm
sali22561
Comments
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?
--SA
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
good
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
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 471
1 Maciej Los 325
2 Yogesh Kumar Tyagi 304
3 OriginalGriff 298
4 Prakriti Goyal 200
0 OriginalGriff 6,367
1 Sergey Alexandrovich Kryukov 5,296
2 Maciej Los 3,384
3 Peter Leow 3,259
4 DamithSL 2,490


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 25 Nov 2012
Copyright © CodeProject, 1999-2014
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