Enterprise Manager Script Templates

• richardx

  Ten Centuries

  Points: 1263

  More actions

  September 3, 2004 at 9:50 am

  #86364

  In Enterprise Manager, you have a variety of options to script objects in the database. (I'm not talking about the helper script templates in Query Analyzer.)

  Is there any way to modify the templates that are used to generate those scripts?

  For example, when a "create table" script is generated, the output is formatted in a particular way. I'm seeking to change the way that output is generated.

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  September 3, 2004 at 10:25 am

  #521688

  I don't think you can change the templates in the formatting tab of Generate SQL Script. Alternately, you can use SQL-DMO to generate a script.