Click here to Skip to main content
12,446,525 members (54,386 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-server-2005 VB SQL-Server , +
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
sali22391
Comments
   
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 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
 
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
Top Experts
Last 24hrsThis month


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