ExecuteNonQuery against a stored procedure does not insert ntext f

G

Guest

Hi,

I have an SP that inserts some data including an ntext field for large
strings (4 M chars)

When executed, ExecuteNonQuery returns -1, but the insertion occurs with all
but the ntext field populated correctly, the ntext field is blank. The string
is an xml fragment.

Any ideas?

Regards
 
W

W.G. Ryan - MVP

I'd run profiler and see what's actually being sent back to the server, just
to verify my assumptions were correct. That should shed some insight into
the problem.
 
G

Guest

Thanx for that.

Solved it in the end, data was being saved, just not displayed in VS!! The
-1 is still a mystery.

Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SqlCe Insert / Replace NText Problem 0
ExecuteNonQuery and Stored Procedure 3
stored procedure 1
Updating a timestamp field using a stored procedure 3
how to send an xml dataset to a Stored Procedure in mssql 2
Call SQL Stored procedure with Bit datatype 6
dataset - Insert-query with stored procedure using wizard 2
Need help improving the following stored procedure 2

Top