In my program I have to generate a stored procedure depending on a large
number of other dinamicaly generated stored procedures. That is why my
procedure text is getting bigger than 64K.
The problem is that when I try to generate the stored procedure from my
program with a query containing something like:

create procedure <name> as
....
a lot of text
...
at the server (which by the way is a MSSQL 7.0) the query text will apear
corrupt.

Do you have any idea why this happen ?
By the way I tried the create statement in the sql explorer and it is
working !

any thoughts will be appreciated,
thx,
Kosta