Skip error and generate a script

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  January 9, 2014 at 2:25 pm

  #302620

  In tasks, generate scripts, I select all store procedures to generate scripts for all sp.

  There are about 200 sp. When run generating about 50th sp, there is an error and then job stop.

  How to set up job to skip error and run generating scripts for next sp?

• Sreekanth B

  SSCertifiable

  Points: 6145

  More actions

  January 9, 2014 at 2:40 pm

  #1678982

  By default SSMS generate Script task has "Continue Scripting on Error" set to false. You can change it to TURE by clicking on Advanced Button.

  Please see attached screenshot for what am talking about. Hope this helps...