|
Home > Archive > MS SQL Server New Users > November 2005 > Running Stored Procedure from another Database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Running Stored Procedure from another Database
|
|
|
| Hi all,
I'm hoping that perhaps someone could help me with a question. I am
running SQL Server 2000 standard edition. I have two databases, say A &
B, what I would like to know is whether it is possible to call a stored
procedure in database B from a stored procedure in database A? I've
tried to use the USE command, however I cannot get that to work. Is this
possible? Or are there any alternative I can look at.
Thanks in Advance,
Hez
| |
| Raymond D'Anjou 2005-11-15, 1:23 pm |
| exec B.owner.storedProcedureName
"Hez" <hez@nospam.com> wrote in message
news:uaQlUSh6FHA.2616@TK2MSFTNGP15.phx.gbl...
> Hi all,
>
> I'm hoping that perhaps someone could help me with a question. I am
> running SQL Server 2000 standard edition. I have two databases, say A & B,
> what I would like to know is whether it is possible to call a stored
> procedure in database B from a stored procedure in database A? I've tried
> to use the USE command, however I cannot get that to work. Is this
> possible? Or are there any alternative I can look at.
>
> Thanks in Advance,
>
>
> Hez
| |
|
| Thanks for the quick reply :), I'll try it out.
Raymond D'Anjou wrote:
[color=darkred]
> exec B.owner. storedProcedureName[
/color]
|
|
|
|
|