selecting results to file solved the problem.

However after going through the link provided by you, it seems that the limit is 33 mil records that can be dispalyed in SSMS. In my case it was not even few hundred records when it was breaking. Although it worked, dont know real reason for it.

thanks anyway!