Post reply

implement DDL trigger but one problem i am facing

  • November 18, 2008 at 8:47 am

    #126050

    I need to keep tracking of Database objects changes..

    For that i have implement DDL trigger but one problem i am facing..

    All changes are tracked well for Procedure and functions, but when i change column dataType or add new column from UI..It genereates scripis like

    create tmp_tablename (id..etc)

    drop table tablename

    and when i chane from analyzer , then got weel scriprs..

    any idea?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • November 18, 2008 at 9:54 pm

    #900291

    Is there any way to track Databbase object changes...so that after track those changes i can apply thos changes on live servers from scripts generated from track..???

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

Viewing 2 posts - 1 through 1 (of 1 total)

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