ExecuteNonQuery against a stored procedure does not insert ntext f

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Thanx for that.

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

Regards
 
Back
Top