Post reply

Calling a stored procedure in another database

  • December 7, 2007 at 3:15 pm

    #70525

    I have a stored procedure that I want to call a second stored procedure in another database (which will return a list based on the name passed in as a parameter). I am using the following call

    "EXEC SecondProcSynonym @paramName"

    But it is not working. Any ideas? Thanks!

  • December 8, 2007 at 10:15 pm

    #758353

    you can just use 3 part naming if the db is on the same server:

    exec OtherDB.dbo.ProcName @myparam=1234

    ---------------------------------------
    elsasoft.org

  • December 10, 2007 at 10:21 am

    #758660

    Thanks! I was not passing along the parameter correctly. 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply