Post reply

audit trail

  • December 23, 2003 at 7:22 pm

    #83269

    hi friends

    i've database of 20 tables.and my task is to create audit trail everytime a user updates any of the 20 tables.what i'm doing is creating a trigger on a table i want 2 audit

    which will log this activity in to log table.

    my question is say if i've 50 tables an i want to audit all of them then i need 2 create 50 triggers right?

    i am wondering if there is any better/simpler way.

  • December 24, 2003 at 5:53 am

    #487725

    If you are going to use trigger then yes, you will have to create one trigger per table.

    Or you can also run continuosly profiler to log the updates.

    Or also create stored procedures to run the updates and also log into a table. Give permission to the stored procedure and remove the access to the table. So that, all users use your stored procedure.

  • December 24, 2003 at 6:53 am

    #487733

    You can buy a product to do this, such as Entegra,OminiAudit, or VigilEnt.

    --Jonathan



    --Jonathan

  • December 28, 2003 at 12:38 pm

    #487864

    Hi Jonathan & racosta

    Thank u very much for ur reply.

    sorry i'm in late in reply as i was in christamas holidays.

    Hope u guys had great christamas.

    cheers

  • December 29, 2003 at 1:00 am

    #487885

    I believe Yukon will allow you to create system or server level triggers which would do what you need, Entegra,which Jonathan mentioned will do this now.

    HTH

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • December 29, 2003 at 12:33 pm

    #488037

    Thanks Ray

    my company is not willing to invest any amt

    in buying those 3rd party tools.

    may b i need to stick to my earlier plan.

    cheers

  • December 29, 2003 at 12:37 pm

    #488038

    Yep, if you didn't know Yukon is the next version of SQL Server due to be released end of 2004, if you can wait that long you can have what you want included in Yukon.

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • December 29, 2003 at 12:52 pm

    #488044

    frankly i didnot know aby yukon.

    thanks for telling me abt it.

    cheers

  • December 29, 2003 at 3:34 pm

    #488081

    Here's one URL that will get you started,

    http://www.microsoft.com/sql/yukon/productinfo/

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • December 29, 2003 at 3:44 pm

    #488082

    cheers ray

    i'll look at it.

Viewing 10 posts - 1 through 9 (of 9 total)

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