Home Forums Article Discussions Article Discussions by Author Discuss content posted by David Dye Monitoring Changes in Your Database Using DDL Triggers RE: Monitoring Changes in Your Database Using DDL Triggers

  • October 7, 2008 at 2:17 pm

    #881962

    Pieter (10/7/2008)

    thanks Wayne!

    We do data warehousing instead of OLTP and like the space savings associated with "set ansi_padding off". Is there a way that we can make it work and have the audit trail?

    Thanks,

    Piet

    Sorry, can't help you there, Piet. I'm strictly an OLTP guy, I don't work with DW at all.

    Myself, I much prefer ANSI padding off, I hate having to trim fields before concatenating.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]