this seems to be a dupe of this thread: SQL Parameters using Varchar(Max) columns
i also note that Tableau has posted a KB on it as well: Error "The size (9999999) given to the column "Column" exceeds the maximum allowed for any data type (8000)" | Tableau S…
I solved this issue in this way:
SUBSTRING ("MyTable.MyColumn", 1, 3999) "NameColumn"
This code is in the stored procedure, in SQL server, I just changed the length of the string. This works for me.
Thanks for the answer!