Ok I will take a look.

Thanks.

I found the solution to my problem.

SQL Server agent's default textsize is 1024 whereas SSMS default is 2147483647.

So specifiying SET TEXTSIZE 2147483647 solves the problem. This might be useful...

Yes, I understand and i would love to learn that technique. I just want to be sure that there is no way to make it work withe SQl Agent.

I don't know much about SQLCLR. That's why i prefer using OLE automation procedures. But it's weird, because it seems to be one parameter that causes the limitation. But i...