In SMS I'm getting 'Could Not Find Stored Procedure...' and I'm staring right at it.
Posted on 2011-10-05
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:
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.