Post reply

Linked server and stored Procedures

  • March 1, 2019 at 3:32 pm

    #382853

    I created a linked server.
    And also enabled the server option of RPC out to true.

    I am able to connect to the linked server and execute stored procedure on it.
    But In SSMS under linked server I can only see list of  tables and views, but I cannot see any stored procedures listed.
    Is that normal or something wrong?

    Thanks

  • March 1, 2019 at 4:16 pm

    #2023356

    sqlfriends - Friday, March 1, 2019 3:32 PM

    I created a linked server.
    And also enabled the server option of RPC out to true.

    I am able to connect to the linked server and execute stored procedure on it.
    But In SSMS under linked server I can only see list of  tables and views, but I cannot see any stored procedures listed.
    Is that normal or something wrong?

    Thanks

    That's normal.

    Sue

  • March 1, 2019 at 4:20 pm

    #2023357

    Thanks, is there document that mentioned that?

    THanks

  • March 1, 2019 at 4:49 pm

    #2023358

    sqlfriends - Friday, March 1, 2019 4:20 PM

    Thanks, is there document that mentioned that?

    THanks

    Maybe somewhere but nothing that I'm aware of. 

    Sue

  • March 1, 2019 at 5:05 pm

    #2023359

    you may not be able to see them on ssms - but you can still execute them on the remote server.

  • March 1, 2019 at 5:29 pm

    #2023362

    yes, I can execute it like I said in my original post. But just wonder why it is not shown in the list in SSMS.

Viewing 6 posts - 1 through 6 (of 6 total)

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