Results 1 to 25 of 25

Thread: Logging User Activity in MSSQL [RESOLVED]

Threaded View

  1. Jun 27th, 2005, 03:37 AM #15
    erickwidya
    erickwidya is offline

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

    save to .txt as result from SELECT query

    just realize something..instead i "force" to use Tables the log, why don't i use text base (.txt) to save it so that method that kaffenils and szlamany's suggest can be implemented
    Code:
    Insert into ArchiveTable GetDate(),System_User,Columns_Updated(),* From Inserted
    i think the bold part can be use now without have to worry about table's columns count anymore but how?

    EDIT : which one is "do-able"?

    i search in BOL and could not find any helpful information

    thanks
    Last edited by erickwidya; Jun 27th, 2005 at 05:00 AM.

    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