How to have sp in one db call another sp in another db [Archive]

Click to See Complete Forum and Search --> : How to have sp in one db call another sp in another db

mfisher

07-12-2005, 03:59 PM

Hello,

I am not sure how to do this, can someone please help.

From one stored procedure in one database, how do I call another stored procedure in another database???

The are on the same server and I'm hoping this is a simple call rather than any complex configuration settings required.

In advance, thank you
Micheal

marist89

07-12-2005, 04:27 PM

You'll need a database link pointing to the other database. In addition, you may want to setup a synonym on your side that points through the link to the package/sp that you want to execute.