I have a C# application that inserts XML into Sql Server 2005. When the message is more than 300 lines or so, it doesn't make it there. The data shows in the application variables (stringWriter) but doesn't get inserted and that's confirmed
looking in Profiler.
The stored procedure is simply:
usp_WS_OrderEntry_InsertWSOrder @doc=@p1,@WSOrderId=@p2 output
INSERT INTO WS_OrderEntry_Order (OrderXML) VALUES(@doc) .....
tableAdapter.usp_WS_OrderEntry_InsertWSOrder(stringWriter.ToString(), ref wsOrderId);
In any cases, the variable "stringWriter" contains the data (as text).
In profiler for a successfull call:
declare @p1 xml
declare @p2 int
exec dbo.usp_WS_OrderEntry_InsertWSOrder @doc=@p1,@WSOrderId=@p2 output
In unsuccessfull call:
It shokes on the convert part and doesn't display any data (and doesn't insert as well). I looked in LOGs, events and didn't find anything.
Any help appreciated. Thanks.
View Complete Post