Calling Stored Procedure in External DB

Calling Stored Procedure in External DB

  
On the same SQL server instance we've another database.
We want to call a stored procedure in that database.
When we do that, we got this error ... what to do ?

Hi, Joop.
 
Take a look to this post:
 
 
Paulo Tavares is describing how to Grant Execute permissions to OSRuntime, your problem is similar, but, your stored procedure is not at the same database.
In order to solve your problem, you may create a linked server and execute the stored procedures with it.

You should also change your advance query to call the stored procedure with the linked server context:
EXEC LINKEDSERVERNAME.CATALOGNAME.dbo.SPNAME
Hope it helps you.
 
Regards.

Daniel Martins