Topic: error on altering many SPs in the same QA window

• johnsql-193053

  SSCommitted

  Points: 1657

  More actions

  July 26, 2007 at 6:51 am

  #119939

  Buddies,

    I get an SQL error message such as "alter procedure statement should be on the top of other alter statements" when I open only one QA window to re-compile multiple stored procedures (SPs). In otherwords, in the same QA window instance, I get that error when runing batch scripts like:

   

  alter procedure myprocedure1

  ...

   

  alter procedure myprocedure2

  ...

   

    The problem is gone when I re-compile one stored procedure in a separate QA window.

    Can somebody please have any idea for me of how I can run multiple "alter procedure..." batch statements in the same QA window isntance?

    Thanks so much in advance.

  Johnsql

• Shawn McGehee

  Ten Centuries

  Points: 1239

  More actions

  July 26, 2007 at 7:16 am

  #722560

  Make sure to place a GO statement after each SP you are modifying. 

  If this isn't the problem, could you post some example code so we can see exactly what you are working with?

• johnsql-193053

  SSCommitted

  Points: 1657

  More actions

  July 30, 2007 at 9:07 am

  #723325

  Shawn,

    Thanks for your great hint. I add the GO statement after each SP and the batch script works fine.

  Johnsql