Create Log tables and Triggers

• Srinivasulu

  Grasshopper

  Points: 19

  More actions

  September 27, 2007 at 2:27 pm

  #175236

  Comments posted to this topic are about the item Create Log tables and Triggers

  ---

  Kind Regards,

  Srinivasulu
  

• Sorin Petcu

  Hall of Fame

  Points: 3195

  More actions

  October 26, 2007 at 1:07 am

  #745598

  This audit has not information about date/time of operation and who operated. It has only the activity - type of operation. It is not a real audit.

  In Theory, theory and practice are the same...In practice, they are not.

• goodguy

  SSCertifiable

  Points: 5456

  More actions

  November 13, 2007 at 6:18 am

  #750630

  Srini, thank you for such a useful and beautiful piece of code!

  1. However, when I ran the script and then the sproc, I found it only created log_tables for 17 out of 75 user tables. Any idea why?

  2. At the risk of sounding ungrateful, though, I would like to request an enhancement that would greatly add value to the log table: The current script logs the affected record with the activity flag, but it does not show the date/time stamp the activity occurred or the user responsible.

  I would have adapted your code to include these features, IF I could make sense of it. Would it be asking for too much to have them included?

  ---

  Regards,

  goodguy

  Experience is a bad teacher whose exams precede its lessons
  

• christian501

  Grasshopper

  Points: 15

  More actions

  December 17, 2010 at 4:56 am

  #1264005

  hello,

  when i run the script to build the procedure proc_Insert_To_Log

  i get the following message

  Msg 208, Level 16, State 0, Procedure proc_Insert_To_Log, Line 22

  Invalid object name '#Tmp_Inserted'.

  i run it on sql server 2005

  thanks for the code so far!!!

  greetings and nice holidays and a good new year!!!