sql - sp_executesql parameter size limit -

i have captured query generated entity framework 1 of parameters can store large amount (400,000+ characters) of text information in nvarchar(max) field. problem have when executing statement string truncated 43679 characters. happens if entity framework executes query or if execute query window.

is there limit on size of entire sp_executesql statement or size of individual parameter statement?

table schema

generated query

i have excluded large string (markup) spaces sake.

exec sp_executesql n'insert [cdp].[content]([projectid], [version], [dateadded], [owner], [markup], [state]) values (@0, @1, @2, @3, @4, @5) select [contentid] [cdp].[content] @@rowcount > 0 , [contentid] = scope_identity()',n'@0 int,@1 int,@2 datetime2(7),@3 nvarchar(128),@4 nvarchar(max) ,@5 int',@0=193,@1=0,@2='2015-07-17 12:48:22.1168801',@3=n'<system>',@4=n'[[400000 charater string]]',@5=1 

management studio , other editors truncate display of long text @ point, should verify length of inserted data querying table select len(markup) ...