dcsimg
Results 1 to 3 of 3

Thread: Pass sproc = Table-valued parameters are not allowed in remote calls between servers.

  1. #1

    Thread Starter
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    5,546

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

    Hi.
    I'm trying to pass a table type from the server to a stored procedure on a linked server.
    After reading tons of stuff, I can't find a single solid example that It will make this work. And most of the examples just do a select.
    That is not what I wan't.
    I wan't to pass a sproc with the tabled value.
    SO
    Code:
    CREATE TYPE LocationTable AS TABLE   
    (trans int)
    end
    ---blah blahh fill data on LocationTable set it as @LocationTVP
    
    --And
    
    
    declare @SqlString nvarchar(2000)
    declare @ParamDef nvarchar(2000)
    
    	  EXEC @RCREMOTE =  DWCINEMASRV.Vista.dbo.sp_executesql N'zz_DeleteGDPRUsers @LocationTVP;',@LocationTVP;
    I get Table-valued parameters are not allowed in remote calls between servers.

    How Can I pass the parameter?

    Thanks.
    Slow as hell.

  2. #2
    Frenzied Member jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    1,427

    Re: Pass sproc = Table-valued parameters are not allowed in remote calls between serv


  3. #3

    Thread Starter
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    5,546

    Re: Pass sproc = Table-valued parameters are not allowed in remote calls between serv

    Saw this.
    Do not help. One says it's not possible the other uses a Select.
    As I've said I don't want a select.
    Annnnd. I've put it in office development?! Right.
    Anyhow I used a cursor and iterating one by one. That is not my intention but I was in a hurry.
    Slow as hell.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width