application roles

[timscronin]

Is a connection utilizing an application role limited to connecting to one database at a time. For example, my approle A lets me talk to database test. But from test I need to exec an sp which is on database orders?

 

[JayKusch]

Can you execute it as ...

EXEC Orders.dbo.StoredProcName

You could create a stored procedure in Test that has the code above to call an SP in Orders.

Thanks

J. Kusch