Avatar of prairie1
Flag for United States of America

asked on 

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

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.
Microsoft SQL Server 2008Microsoft SQL Server 2005

Avatar of undefined
Last Comment

8/22/2022 - Mon