According to the BOL, sp_executesql allows a NTEXT as the datatype for the parameter that contains the SQL. You're limited to a batch size of 1GB.

-Mike

>I have a large statement @SQL that can dynamically grow up to about 6000 characters.
>
>I need to execute this statement using :
>
>sp_executesql
>
>since the stored procedure parameter accepts only a single variable and the + operator is not allowed, how can I execute this statement using this stored procedure?