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
 

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

Inserting large amounts of text using ntext or text 2
Calling all ADO.Net Guru's 6
SqlCe Insert / Replace NText Problem 0
ExecuteNonQuery and Stored Procedure 3
Updating a timestamp field using a stored procedure 3
Bulk insert 2
scope-identity value without using stored procedures? 2
how to send an xml dataset to a Stored Procedure in mssql 2

Back
Top