Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitmalhotra
Starting Member
1 Post |
 Posted - 2010-09-06 : 21:49:15
|
| Kind of funny but looking at the possible cause to this problem that I've got a text type column called MessageText of MailMessages table. Now whenever I am trying to read this through Java, it is throwing this exception:Java Exception error '80004005' ACD_Exception: No data found Note here that this is not the Java problem because I've been using this program for last 10 years and this problem is only occuring with one record where the messageText size is 15360" select Len(Cast (MessageText as varchar(max))) from MailMessages_Sick "However, as soon as I do this, the program runs smooth:Update MailMessages_Sick set MessageText = substring(MessageText, 0, 100000000 )I am running the following MSSQL version: Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) [select @@version] |
|
|
|
|
|
Text column funny behaviour