I have a prolem in SQL6.5.
I needed to generate a dynamic sql statement and execute it at run time in my
stored procedure.
This was never a problem in sql 7.0 because of sp_executesql and it can accept strings as parameter and these strings can be up to varchar(4000).
But in 6.5 the maximum length that I can define is varchar(255).
The string that I am generaing uses optimizer hints and will exceed this number.
Is there anyother way to deal with this?
On the other hand there is no sp_execute SP in 6.5.
I can use only exec (@string).

Thanks
Sush.