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

Posted on 2011-10-05
Medium Priority
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
  • 2

Expert Comment

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

Accepted Solution

prairie1 earned 0 total points
ID: 36919357
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

ID: 37360245
This was the fix-- Ctrl-Shift-R

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 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