Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Create Log tables and Triggers Expand / Collapse
Author
Message
Posted Thursday, September 27, 2007 2:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 08, 2011 2:36 AM
Points: 5, Visits: 7
Comments posted to this topic are about the item Create Log tables and Triggers


Kind Regards,

Srinivasulu

Post #403727
Posted Friday, October 26, 2007 1:07 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, February 04, 2014 8:18 AM
Points: 620, Visits: 273
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.
Post #415252
Posted Tuesday, November 13, 2007 6:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 01, 2012 3:30 PM
Points: 292, Visits: 1,028
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

Post #421532
Posted Friday, December 17, 2010 4:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 04, 2011 3:46 AM
Points: 1, Visits: 8
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!!!
Post #1036461
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse