Strange. 8152 = "String or binary data would be truncated," which suggests some sort of update failure to me (eg if you are trying to update a 20 character...

This doesn't sound good. I tried doing a Google search on

"hang module hungapp" mmc

and still not getting very far. The evidence seems to implicate hardware and/or some...

For MDAC version, check out this link:

http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

This should help. Not the most elegant, but neither is the format. You will have to amend the letters in the @negs string to correspond properly with your...

Wow, bizarre format.

So is the legacy field always 7 characters long, with an implied decimal point between characters 5 and 6? If so, you should store this data in...

Thanks Bill. What an ace surname!

It does help - thanks.

I had to get the job done yesterday, so I ended up mapping all of the strings to integers to get the import to work, then...

I'm not an MSDE expert, but I would have thought that to gain full access to the MSDE instance from EM, you would need admin username (sa) and password for...

Your problem is obviously as a result of b.response_size sometimes being zero.

Not sure what you want to do about this, but if you wanted to replace it with a '1'...

If you use round(float,0,1), it truncates float to integer (ie 0.5 and above are not rounded up), so the given example actually works OK. Eg

select round(1.999999,0,1) as IntPart

returns 1.000000

I wouldn't bet against it - some bright guys out there.

This link is relevant but not good news. I think you might have to recast as a stored proc.

Regards

Phil

Sounds like one of those (common) applications where integrity is left completely in the hands of the application. As a developer who is new to the db, you have no...

It's looking pretty strange and I'm running out of ideas. Have you checked Event Viewer to see whether any exceptions are being generated?

Have you thought about breaking the transfer...

Same execution plans for all methods -> use the one that makes most sense to you