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?