title: Generate script for triggers only using script wizard
body: <p>I have SQL Server 2008 R2. I have around 150 tables in a database and for each table I have recently created triggers. It is working fine in my local environment. </p>
  
  <p>Now I want to deploy them on my live environment. The question is I want to deploy only the triggers. 
  I tried the <code>Generate Script wizard</code> but it is creating script with table schema along with triggers, NOT triggers only. </p>
  
  <p>Is there anyway to generate all the triggers drop and create type script?</p>