Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2014
    Provided Answers: 7

    Unanswered: ID's for Insert and Modified Fields

    Just curious if you all add ID's with your Inserts and Modified (Date) fields. Such as 1 would indicate if the record was inserted manually, whereas 2 might indicate it was update or inserted by a web application.

    I've never seen tables carry this architecture but now I am seeing it a lot. Doesn't seem incredibly useful.

    Thanks for any follow ups.
    Last edited by VLOOKUP; 01-21-15 at 13:19.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    If I need this type of information, I get and maintain it using an auditing system. Putting the data in the table itself is at best decorative, and easily corrupted (both intentional and inadvertent).

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jan 2007
    Provided Answers: 12
    It's not a requirement I've ever really needed to log before, but it is sometimes something I have had to profile for on occasion.

    If I had to do this, then I would be looking at App_Name(). This will only really work if the application name is specified in the connection strings used, though.
    Home | Blog

Posting Permissions

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