I have an EXECUTE() line which executes the content of a variable. The variable string has 4563 characters. However, if I use this declaration:

DECLARE @SQL nvarchar(max)

...it is not big enough.

I can go higher with this declaration:

DECLARE @SQL nvarchar(4000)

But, it is still not big enough.

Any idea on the proper declaration to host such a big string?