Scripting all Triggers

• normturgeon

  Old Hand

  Points: 337

  More actions

  August 5, 2013 at 4:45 am

  #297172

  Is there a way to script all Triggers in a Database to a text file?

  Thanks

• s_osborne2

  SSCertifiable

  Points: 6726

  More actions

  August 5, 2013 at 5:05 am

  #1638565

  Hi,

  This post here takes you through how to do it:

  http://stackoverflow.com/questions/13200511/how-to-generate-scripts-for-all-triggers-in-database-using-microsoft-sql-server

  But I doubt you can do it without scripting out the tables themselves without the use of a 3rd party tool like SQL Compare from RedGate. Maybe if you're handy with PowerShell you could knock up a script that'll do it.

  Thanks,

  Simon

  ---

  
  MCSE: Data Platform
  MCSE: Business Intelligence
  Follow me on Twitter: @WazzTheBadger
  LinkedIn Profile: Simon Osborne

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  August 5, 2013 at 7:16 am

  #1638590

  Have a look here[/url].

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel