Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

My original #Temporary tables, indexes and procedures work! no longer works, so I edited it to confirm temporary tables and indexes can still work -- and this now doesn't need GO.

The problem with the original query seems to be the handling of GO has broken, but not in the same way as previously. Similarly the three other queries found by searching for CREATE PROC all currently fail.

However CREATE PROC still needs to be "the first statement in a query batch" which you can see if you edit this query or its revisions, where I have tried a number of things relating to GO and CREATE PROC, including starting with confirming the previous issue is not present and including effectively the same query as from MSDN.

share|improve this question
the GO splitting being broken is a regression, will sort it – waffles Jan 18 '12 at 5:54
@waffles Was able to root it out, but the overall code there might be misguided on my part – Tim Stone Jan 18 '12 at 8:50
deployed Tim's fix ... let me know how it goes – waffles Jan 18 '12 at 22:37
up vote 2 down vote accepted

Someone (we'll call that person "me") was trying to be clever and reduce query white space to increase our chances of hitting the execution cache. This reduction was doing the decidedly unclever thing of stealing the newline after your GO in certain cases.

I've now made sure we put it back in my copy of Data Explorer, and we'll see if this operation causes any more problems.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .