Hello,
I'm working on an application that needs to send large serialized data
types through the Service Broker services. The application is written
in C#.
I can serialize the objects into XML and insert them as the xml data
type without issue, but since binary serialized objects are
significantly smaller than XML serialized objects, I was wanting to
try going that route.
I tried declaring an image variable instead of an xml variable for the
send, but I get an error saying that text, ntext and image are not
allowed to be declared.
What do I need to do to send a large binary through the queue?
Max Fuqua
Remus Rusanu [MSFT] - 05 Mar 2007 07:07 GMT
VARBINARY(MAX)
If you use SqlCommand, pass the body as a parameter of type Varbinary with
length -1
HTH,
~ Remus
> Hello,
>
[quoted text clipped - 14 lines]
>
> Max Fuqua