Generate Script / Execute script loses stored proc formatting

• khalprin

  Mr or Mrs. 500

  Points: 576

  More actions

  September 10, 2009 at 3:38 pm

  #156206

  Using SQL Server 2005, I right-clicked my database, selected 'Tasks' and generated a script file to create all the tables and stored procedures.

  I then ran that script to create the tables in a different database as a test and found that all the stored procedures had lost their formatting. In each stored procedure, each line started at the first column (no indentation at all) and all the blank lines were gone.

  Is there a way to preserve the formatting of stored procedures?

  Thanks

• khalprin

  Mr or Mrs. 500

  Points: 576

  More actions

  September 10, 2009 at 5:06 pm

  #1052032

  Disregard this question... I think it may have been my script 'feeder' program.