Results 1 to 25 of 25

Thread: Logging User Activity in MSSQL [RESOLVED]

Threaded View

  1. Jun 22nd, 2005, 04:42 AM #1
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Resolved Logging User Activity in MSSQL [RESOLVED]

    currently i'm using TRIGGER for INSERT, DELETE, UPDATE which Insert new record to tblLogs
    the table structure = UserName | DateTime | ActionTaken (I, D, U) | TableName

    everything works fine until i realize that i missed important thing which is the "ColumnName" that user changed coz in here User seem easily forgotten what they have done, that's why i planning using the tblLogs

    so the question would be How (if not involved complicated method)? or any other better method?

    i open for any idea

    thanks
    Last edited by erickwidya; Jun 28th, 2005 at 09:07 PM.

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width