Re: ntext getting truncated

Jack,

How are you seeing that the data has been truncated? If you are seeing the truncated results in your Access application, then they are certainly being truncated and Tom's advice is good for you.

If you are seeing the truncated results in SQL Server Management Studio, or in Query Analyzer, you may be suffering from the limits of those tools. In a SQL Server Management Studio query window (for example) select the mnu path Tools \ Options, then in the form select Query Results and either Results to Grid or Results to Text to see the maximum number of characters setting.

To check for how long your ntexts are being, you could see the distribution of lengths by a query, such as:

SELECT TOP 100 * FROM (
select count(*) howmany, datalength(ntextcol) ntextlength
from yourtable
group by datalength(ntextcol) ) AS sizes
order by howmany desc

RLF



"Jack" <Jack@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9006ECEA-FB6A-431E-8D2C-06198976553E@xxxxxxxxxxxxxxxx
Hi I have an access application with linked table to sql server. One of the
linked table in access is memo field while the corresponding sql server field
is ntext. From the front end of the application one can add rather big
description of problem in the memo field. However in the corresponding sql
server field(ntext) part of the problem descriptioin is getting truncated. I
am not sure why. The form fields are directly linked to the linked sql server
table.

I appreciate any help for resolution of this issue.
Thanks.

.

Relevant Pages

  • Re: ntext getting truncated
    ... Thanks Tom and Russell for the help. ... in Query Analyzer, you may be suffering from the limits of those tools. ... a SQL Server Management Studio query window select the mnu ... server fieldpart of the problem descriptioin is getting truncated. ...
    (microsoft.public.sqlserver.programming)
  • ntext getting truncated
    ... Hi I have an access application with linked table to sql server. ... description of problem in the memo field. ... server fieldpart of the problem descriptioin is getting truncated. ... I appreciate any help for resolution of this issue. ...
    (microsoft.public.sqlserver.programming)
  • Re: ntext getting truncated
    ... of conversion to, say, an nvarchar is occurring. ... Hi I have an access application with linked table to sql server. ... description of problem in the memo field. ... server fieldpart of the problem descriptioin is getting truncated. ...
    (microsoft.public.sqlserver.programming)
  • Table Question
    ... I have a table on our sql server "dbo_tblWarehouse" that is linked to my ... memo field. ... Is it possible to do it through a query or do I need to have the ... IT guys open it in design view and add it from the server end? ...
    (microsoft.public.access.gettingstarted)
  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
Loading