sql server data warehouse: <Long Text> errors on a 'text char(16)' column -- sql server data warehouse

<Long Text> errors on a 'text char(16)' column

cjeffwang NO[at]SPAM yahoo.com
11/22/2004 3:28:45 PM

sql server data warehouse:

Our SQL Server database is being utilized by many Applix/iHelpdesk
forms. On a cloumn with a 'text char(16)' datatype, we recently found
2 <Long Text> errors on a table. The Applix developers said their
application was locked up. My DBArtisan can disply only two records.
The third row showed a <Long Text> error in the Enterprise Manager.
Was my DBArtisan also locked up?

What kinds of Applix data format caused the the <Long Test> error?
How to solve this problem?

TIA.

Re: <Long Text> errors on a 'text char(16)' column

Adam Machanic
11/22/2004 9:11:32 PM

That's not an error; that's Enterprise Manager not displaying TEXT/NTEXT
properly. Use a better tool (e.g. Query Analyzer) and that problem goes
away.

--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--

[quoted text, click to view]