Post reply

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

  • 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.

  • 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

  • June 28, 2013 at 7:03 am

    #1628280

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

  • 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/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply