Test Data Manager Masking: Masking Functionality about varchar(max)

Document ID : KB000016133
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Will masking and sub-setting work if XML files are stored in SQL varchar(max) data sets?

Answer:

Prior to SQL 2016, there is a MAX of 2000 for each column. If XML data goes beyond 2000, and SQL 2016 and up is being used, the upper limit is 8000.