Text datatype not exceeding 8000 characters

[Rajiya]

Hi, I have a stored procedure which is having a input parameter as TEXT datatype. I am passing a string to it whose length is 9000. It does not accept more then 8000 characters of the string. How to solve this issue? Is there any method in which i can increase the length of the datatype. or is there any other datatype whose datalength is more then 8000? Thanks, Riz

[Krish KP]

to my knowledge 8000 is max. in SQL Server 2000

Regards KP

[Mike Dimmick]

If you're using classic ADO, you must use the adLongVarChar datatype for the parameter, and use AppendChunk to write the data to the parameter rather than simply assigning the Value property. For ADO.NET and the SQL Server data provider, use the SqlDbType.Text type.

Stability. What an interesting concept. -- Chris Maunder

[Rajiya]

Hi, Thanks for ur reply.... I want to know how exactly to implement it in the stored procedure. Can u give me an example? It's very urgent. Thanks, Riz