DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to have sp in one db call another sp in another db

  1. 07-12-2005, 02:59 PM #1
    mfisher
    mfisher is offline Junior Member
    Join Date
    Jul 2005
    Posts
    1

    How to have sp in one db call another sp in another db

    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
    Reply With Quote Reply With Quote
  2. 07-12-2005, 03:27 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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.
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width