Yesterday, I had to run one “CREATE ASYMMETRIC KEY” and a series of “DROP/CREATE PROCEDURE” statements which were separated by “GO” statements.  Anyways, I have all these statements in one window and click on the Run button in SSMS.  This fails with the following error:

Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure ‘A’.

So I google it and find a blog post where the guy says that the letter A is the “first letter in the name of the sp/object that is failing”.  But that doesn’t apply to my situation, since the stored procedures that I am dropping/creating do not start with A.  Anyways, what I did was to run each statement one by one and it worked just fine.

Advertisements