Viewing 4 posts - 1 through 5 (of 5 total)
You are right as it is storing all data into table and checked with LEN command but in SSMS it is now showing. There is limit to 65535.
Is there...
September 4, 2012 at 1:09 pm
#1533476
I also change datatype to text and check the size. It still shows me 43600 characters in SSMS.
September 4, 2012 at 12:59 pm
#1533470
I am checking in SSMS . In ch it shows 43600 characters.
September 4, 2012 at 12:45 pm
#1533465
Yes data is there but its only 43600 characters. But the total size is 115000 characters.
September 4, 2012 at 12:13 pm
#1533453