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 for looking into this. Yes, that's my understanding of the general rule as well.

    Microsoft made an exception to this for table valued parameters (specifically to avoid the memory hit).

    I take it Mr. Kornelis gave no indication that such an exception was also made for large varbinary(max) variables then?

    I wonder if the READONLY keyword changes the memory handling situation for a parameter...