Create Log tables and Triggers

Question

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sorin Petcu Hall of Fame Points: 3195 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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!!!