I have written a SQL code generator where end users can define their own tables independent of developers. These are financial tables and so the structure can be quite weird and row size can exceed 8k. To tackle this for these tables i am using NVARCHAR(MAX) as data types for the columns and also using
EXEC sys.sp_tableoption 'dbo.table_names','large value types out of row','ON'
but still i get the following error message.
Cannot create a row of size 9307 which is greater than the allowable maximum row size of 8060.
Can you please help?
I have attached the file of one of the tables