Thanks, I'll take a look at it...

So many fun things to learn about..

Ilmar

Not in this one..

Language for the odbc connection is Visual FoxPro.. we are in the process of porting a large application from VFP as a back end to SQL...

Thanks guys..

Mike nailed it..

"** Note that the largest number of characters viewable in query analyzer is 8192 bytes (Tools | Options | Results)." 

That was the problem (I'm still...

Oh.. and in both cases, the insert command (either typed directly into the query analyser or sent via the odbc connection) is just:

Insert into nmsErrorLog (error,listing)

Values

('Test Long Error','Error # 16.....')  where...

I've tried two ways of inserting:

1. via an odbc connection

2. directly in the query analyzer

And two ways of viewing (both in the query analyser):

1. select * from nmsErrorLog where...

Thanks.. I'm now  using something similar to turn constraints off and then on again.. but I still have the issue that sometimes one record with bad data will stop the...