Post reply

Attaching triggers

  • June 20, 2005 at 4:30 pm

    #66622

    hi,

    we have triggers attached to several. everytime there is a change or Replication need to be re-established, triggers have to be manually attached.

    my question  - is there a way to automate or write a script to attach the triggers to each table ?

    Thanks

    -AG

  • June 20, 2005 at 7:11 pm

    #566919

    If you do your scripting via the EM scripting wizard you can specify "script triggers" under the options tab - in fact, the table scripting options will script indexes, primary key constraints et al...this would be the easiest way!

    You could also view a list of all triggers in a given database by doing a

    "select name from sysobjects where xtype = 'tr'"







    **ASCII stupid question, get a stupid ANSI !!!**

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

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