Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6

    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
    Location
    In front of the computer
    Posts
    15,579
    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).

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

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    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.
    George
    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
  •