How Can I Include A Rowverson Column In A Table Valued Parameter When Calling A Stored Procedure?

If I have a SQLDataRecord that includes a RowVersion column as shown in the code below. I always get a SQL Server Error 8052 The incoming tabular data stream (TDS) remote proce

Solution 1:

You can never control the contents of a rowversion column - but you've indicated that you want to provide specific values for existing rows.

That would indicate that you should use binary(8) or varbinary(8) (depending on not-NULL/NULL, respectively) as the data type for that column in the TVP instead.