How to avoid this error when scripting multiple sp? Thanks.

• halifaxdal

  SSCoach

  Points: 19741

  More actions

  June 27, 2013 at 2:42 pm

  #274612

  I have multiple sp with @sql defined, when I script these sp, it throws error saying @spl already defined, well, true or false, in the final generated script, yes; but I want to re-generate all the sp in a new database, eventually there would be multiple sp generated and those @sql will fall into different sp and hence @sql is NOT already defined.

  How do I avoid this error?

  Thanks.

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  June 27, 2013 at 3:18 pm

  #1628143

  Use a batch separator (aka GO);-)

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• halifaxdal

  SSCoach

  Points: 19741

  More actions

  June 28, 2013 at 7:03 am

  #1628280

  That's easy, isn't it? Thank you.

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  June 28, 2013 at 7:11 am

  #1628281

  Use Go batch separator as Luis suggested...

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/