passing max value for nvarchar from code

 .I recently used the nvarchar(max) data type for one of the SP and had difficulty setting the parameter size from code. Setting the parameter the size to -1 to get it to work.

read more
http://weblogs.asp.net/jeffwids/archive/2008/08/15/nvarchar-max-parameters-need-the-size-set-to-1.aspx

cheers
samitha