<div>
you need to write down the full name of the proc, something like this <br />
Exec dbo.ProcedureB<br />

</div>


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


<div>
This was the fix-- Ctrl-Shift-R
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
I'm using sql-server 2008R2. <br />
I connected to SMS via Windows Auth, I have sysadmin and serveradmin.<br />
I created procedureA in SMS. &nbsp;Then I created ProcedureB in SMS. &nbsp;I granted Public role the Execute permission on both procedures<br />
Then I went back to ProcedureA and put in the line:<br />
Exec ProcedureB<br />
I get the squiggly red line saying 'Could not find procedure...blah' &nbsp;<br />
I can see both prodecures right next to each other, both owned by dbo, etc. <br />
If I disconnect and re-connect using sql-auth as sa, the squiggly line is gone and all is fine.<br />
It's as if this procedureB isn't seen by anyone under Windows Auth, but public has permissions so I don't get it.<br />
Thanks,<br />
--Jim
</div>
</div>


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.
Thanks,
--Jim

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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.