Just update on this : I was able to insert the Text , it was SSMS clipboard issue. When i copy text it is not copying entire text and thats why i mistook that text is not downloaded entirly.
Can i increase the SSMS clipboard size?
It's not the clipboard size. The results grids have a character limit it will display per column, the 4000 you were seeing.