I know that syscomments stores the stored procedures in chunks of 4000 characters. Some of my Stored proc's are >4000 characters.I use a temporary table to stock them after some modifications made to them.How can I execute them one by one, do i need to concatenate one whole stored proc's text in one single line(if yes, how can that be done?) Can variables be dynamically created, assigned values and then destroyed? Please help.
thanks for replying..i can't change the way i'm doing this since it's only a part of the final picture, but if u cud just let me know the way to concatenate multiple TEXT lines(the maximum number of lines can change) stored in multiple rows into one single line in one single row.