DataType to store characters of length 10000 in SQL Server 2008
<p>DataType to store characters of length 10000 in SQL Server 2008 , I tried using VARCHAR(MAX) , also nVARCHAR(MAX) none are of help.
I am declaring one output variable in dynamicSP, which I want to be of size greater than 10k characters.</p>

<p>Thanks!</p>