sql server 2008 limit on exec statement

I just needed to double check if there is a limit of characters on EXEC command in t-sql? If I have a variable with varchar(max) and exec开发者_如何转开发ute the command using EXEC, you reckon that would be ok?

thanks

Should be fine, according to this MSDN article.

The relevant part:

Using EXECUTE with a Character String

In earlier versions of SQL Server, character strings are limited to 8,000 bytes. This requires concatenating large strings for dynamic execution. In SQL Server, the varchar(max) and nvarchar(max) data types can be specified that allow for character strings to be up to 2 gigabytes of data.