I wish to insert large ammounts of character data into a SQLServer DB 

using 



ADO.NET.



Varchar(8000) is not large enough, so I used 'TEXT' Datatype.



However the SPROC will not compile when written along thses lines:



CREATE...

(

	@Title varchar(200),

	@Body	Text

)

AS

SELECT

	@Title = Title

	@Body = Body

FROM

...





The error message is, This asignment '@B... = Body' is not alowed with the 

text data type... Not very useful.



Any ways to make this work or techniques to insert and retrieve Text data 

using ADO.NET/SQL Server would be gratefully revieved.