Parameter maximum string size question

Does anyone happen to know what is the maximum string size that can be passed in a parameter w/o it truncating or throwing an error?

Thank you in advance,

As it is implemented as a .NET type (System.String) it could take theoretically up to 2^31-1 chars, but passing the parameter through the webservice or the URL will make you only to have your URL expanded to the maximum of 2083 chars to support all the methods like GET / POST / Webservices.

http://support.microsoft.com/default.aspx?scid=KB;en-us;q208427

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Thank you Jens. I believe that is what I was looking for.