Home Forums SQL Server 2008 T-SQL (SS2K8) Varbinary(max) parameters in Nested Stored Procedures by value or reference RE: Varbinary(max) parameters in Nested Stored Procedures by value or reference

  • Thanks,

    I understand the initial call to sql server requires parameters be copied. I'm not asking the question very well, I guess.

    In the following chain where SPR1 and SPR2 receive the same varbinary(max):

    Call from client to ->SPR1: we get a new copy of varbinary(max) created on sql server.

    ...SPR1 does some stuff...

    Call from SPR1->SPR2: ?? do we get a new copy of varbinary(max) with associated memory hit.

    ...SPR2 returns, SPR1 does some more stuff...