Executing Sql Script Stored In Text Field.

Hello,

I need to dynamically construct sql script for procedure/trigger of the SQL
Server 6.5 database. Because of length, I need to store it in a text field
of the temporary table. Now I need to execute it.
I see only two choices:
1. Use bcp utility to pass text of procedure/trigger to the text file on
hard drive and the use isql utility to execute that text.
Drawbacks of this way: bcp and isql must be in place, need to write to the
use's hard drive, overhead for large number of modifying objects

2. Declare up to 255 (this is the max number of colid column in the
syscomments table) local variables of varchar(255) type, get sequential
chunks from that text field and build final statement like this:
exec(@var1 + @var2 + ... + @var255)
Drawbacks: need to keep truck of length of the text field to calculate
right number of local variables, and it looks a little bit ugly

While both ways work, I am looking for more nicer way to do this job.

Does anybody know another way to do this?


Thank you in advance,
Oleg Cherkashin