Post reply

Table-valued parameters are not allowed in remote calls between servers.

  • April 1, 2011 at 2:35 am

    #234155

    Hi All,

    i'm trying to pass the TVP to a remote procedure, but it is throwing error

    Msg 7380, Level 16, State 1, Line 62

    Table-valued parameters are not allowed in remote calls between servers.

    If the TVP having this limitation , how can i pass the Collections of multiple items to RPC.

    Can anybody please help me to fix this issue.

    Thanks & Regards

    Deepak.A

  • April 1, 2011 at 5:07 am

    #1306395

    If you have to pass large amounts of data between servers, either exporting to file or XML would be the way to go.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 1, 2011 at 6:32 am

    #1306434

    hi GRant,

    Thanks for reply,

    i tried to pass XML as parameter , event that is also thrown the error.. is there any other way we can pass the collection of items accorss the server to the RPC

    Thanks & regards

    Deepak.A

  • April 1, 2011 at 6:40 am

    #1306439

    I guess it really depends on what the error is. XML is THE method of sending messages remotely. It's how BizTalk works. You can certainly use XML as a means of passing data.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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