Post reply

Script Wizard - DML Triggers

  • January 12, 2012 at 8:10 am

    #251281

    Does anyone know how to generate scripts through the wizard for all the DML Triggers in the database ?

    looks like the only option they have is for DDL Triggers.

  • January 12, 2012 at 8:55 am

    #1432607

    Dont think this is possible. I think you'll have to query the schema and use SMO and powershell to generate them!

    Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified

  • January 12, 2012 at 8:56 am

    #1432610

    it might be easier to simply do it via TSQL:

    select definition from sys.triggers

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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