Post reply

audit trail

  • 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 9 posts - 1 through 10 (of 10 total)

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