In SMS I'm getting 'Could Not Find Stored Procedure...' and I'm staring right at it.

Posted on 2011-10-05
Last Modified: 2012-06-21
Hi all,
I'm using sql-server 2008R2.
I connected to SMS via Windows Auth, I have sysadmin and serveradmin.
I created procedureA in SMS.  Then I created ProcedureB in SMS.  I granted Public role the Execute permission on both procedures
Then I went back to ProcedureA and put in the line:
Exec ProcedureB
I get the squiggly red line saying 'Could not find procedure...blah'  
I can see both prodecures right next to each other, both owned by dbo, etc.
If I disconnect and re-connect using sql-auth as sa, the squiggly line is gone and all is fine.
It's as if this procedureB isn't seen by anyone under Windows Auth, but public has permissions so I don't get it.
Question by:prairie1
    LVL 2

    Expert Comment

    you need to write down the full name of the proc, something like this
    Exec dbo.ProcedureB

    Accepted Solution

    No, I've done that, even used the full 4-part name and nothing.
    I think I found it though--I googled some more and found that I had to go to the Menu in SMS and do Edit-->Intellisense-->Refresh Local Cache (Ctrl-Shift-R).

    That worked, but I find it very odd becuase this has *never* happend before and I've built two within the same session, where one calls the other--and I didn't get this error.  I don't know why  it happened this time.

    Author Closing Comment

    This was the fix-- Ctrl-Shift-R

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now