Partial insert/update error.

[c81...@my-dejanews.com]

In the database the error
[MicroSoft][ODBC SQL Server Driver]Warning: Partial insert/update. The
insert/update of a text or image column(s) did not succeed.

I'm using only text fields and no image columns.

Also we are experiencing frequent lockups. With the sql monitor we can see
that a few persons are blocking the database. The problem resolves itself
after a while but the performance of the application is decreasing rapidly.

The MiscroSoft MSDN library does not provide any usefull info about the error
and how to resolve it.

Questions:
- Has anyone an idea ho to resolve the error given
- What is the cause or what might be causing the error
- I added table constraints. Is this causing the error?

Any suggestions are welcome.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

[sym...@yahoo.com]

So many questions <G>

First off sp_lock ( or sp_lock2 ,this will also be blocked though if
the temp tables are locked) will tell you which tables are being
blocked on.

I did find a reference to the ODBC error in BOL under the 'DataType
Usage' section, but this related to 4.

Dave

In article <7hp48o$cpf$1...@nnrp1.deja.com>,

--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---