Problem updating NText field and query timeout

[Chris Asaipillai]

Hi there

Has anybody experienced Timeout issues on updating NText fields in SQL
Server 2005?

Ive been using a procedure in an MS Access application, to read in the
contents of an Ntext
field used for notes into a local string variable.

Then further notes are added to this and then an update statement writes it
back to the NText
field.

Ive used an updateText procedure but this is also timing out.

The field has been in use and has been updated to before.

many thanks

Chris

 

[dbahooker]

i've had to use WRITETEXT and READTEXT and all those string pointer
things before.. and it usually seems to work just like it's reccomended
in SQL Books Online.

give us some of your code.. and tell us how large these text strings
are.. ok?

-Aaron