can someone tell me what the best solution is for creating logging system (Audit trail) !? I'm using vb.net with MSSQL 2005
the following thread will give you some tips about audio trail mechanism :
http://www.universalthread.com/ViewPageArticle.aspx?ID=615