From: Roy Goldhammer on
Hello there

I am building system which take procedures from one place, displaying the
script of store procedure and then i taking it and run it in a different
server.

But if the procedure script is more then 8192 it cutts it in the result.

Is there a way not to cut it?


From: John Bell on
On Thu, 8 Jul 2010 17:24:54 +0300, "Roy Goldhammer" <royg(a)yahoo.com>
wrote:

>Hello there
>
>I am building system which take procedures from one place, displaying the
>script of store procedure and then i taking it and run it in a different
>server.
>
>But if the procedure script is more then 8192 it cutts it in the result.
>
>Is there a way not to cut it?
>

This may help
http://sqlblogcasts.com/blogs/martinbell/archive/2009/10/25/How-to-display-long-text-in-SSMS.aspx

John