Extended Stored Procedures

  • I am trying to call a extended stored procedure that resides on a linked server? I am getting a message saying that I can only have a maximum of 2 prefixes.

    Is this a limitation for extended stored procedures or is there a work around?

    Thanks.

     

  • One more thing, I am trying to call the extended stored procedure from within a function. I have just read somewhere on another forum that a Remote function calls are not allowed within a function. Is this correct?

    Thanks.

  • That's right. Only local extended stored procs can be called from a UDF.


    Cheers,
    - Mark

  • thanks.

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

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