The execution plan of the same stored procedure was massed again today. What could be the causes to corrupt the execution plan of the same stored procedure? By my knowledge...

You're probably right. Somehow the cached excution plan was messed up.

Thanks for your help!

--- Lu

Thanks guys so much!

I have tried to put <BR> in the text string and it worked when the text field loaded into a rich textbox field.

Thanks!

I have added Chr(13) and Chr(10) in the string variable to update text field. But when I pulled the text back into my application. It did not show the carriage...

When I tried to used OPENROWSET to handle the INSERT instead of a LINKED SERVER, everything worked just fine.

Thanks everybody!

Anyhow, that's what my user wanted?

I tried to run my SQL Server Service under LocalSystem. It stil does not work.

The error message is:

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an...

I will certainly try it.

Thanks a lot!