Post reply

Cross database calls using user defined table type

  • July 13, 2010 at 5:52 pm

    #226817

    Can somone confirm whether it is or is not possible to call cross database functions or procedures where the input parameter is a user defined table type?

    I've tested and it doesn't seem possible, but I can't find anywhere in BOL or anywhere else where it says it's not.

    David

  • July 19, 2010 at 10:22 am

    #1194997

    I have been trying this myself. Some research has revealed that it isn't possible. Seems that all types are database specific and cannot cross lines between them even if the definitions are identical.

    Try looking at this article: http://www.sommarskog.se/share_data.html#prockeyed

    I am going to try the global temp table.

  • July 19, 2010 at 10:54 am

    #1195015

    I have been trying this myself. Some research has revealed that it isn't possible. Seems that all types are database specific and cannot cross lines between them even if the definitions are identical.

    Try looking at this article: http://www.sommarskog.se/share_data.html#prockeyed

    I am going to try the global temp table.

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

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