Passing a large parameter to s stored procedure

We have a developer who is trying to pass a large
parameter (type = text) into a stored procedure. The
parameter he is trying to pass is the contents of a 56mb
XML file.
The procedure works great with the next largest XML file
(about 30mb), but we are getting a network error when
trying to pass this large parameter.
Has anyone run into this... Any ideas
Hi
The batch size is limited to (65'536 * Network Packet Size) or (65'536 * 512
= 33Mb)
The developer neeeds to chunk the data in.
http://msdn.microsoft.com/library/de...ql server.asp
http://msdn.microsoft.com/library/de...pendchunkx.asp
Regards
Mike
"WEX" wrote:

> We have a developer who is trying to pass a large
> parameter (type = text) into a stored procedure. The
> parameter he is trying to pass is the contents of a 56mb
> XML file.
> The procedure works great with the next largest XML file
> (about 30mb), but we are getting a network error when
> trying to pass this large parameter.
> Has anyone run into this... Any ideas
>