Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
johnsql
Posting Yak Master
161 Posts |
 Posted - 2007-07-26 : 08:44:32
|
| 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 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-07-26 : 08:53:37
|
add GO before the 2nd ALTER PROCEDURE
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-26 : 08:53:57
|
Yes you can!But you have to put a batch statement "GO" between each ALTER statements.I think the error message you got explained this.
E 12°55'05.76"N 56°04'39.42" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-26 : 08:56:41
|
 by 20 seconds...
E 12°55'05.76"N 56°04'39.42" |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-07-26 : 09:12:30
|
[code]select count = count + 1[/code]
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
johnsql
Posting Yak Master
161 Posts |
Posted - 2007-07-30 : 10:57:47
|
| Thanks so much for your great helps. |
|
|
|
|
|
|
error on altering many SPs in the same QA window