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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Text being truncated even with a TEXT datatype

Author  Topic 

brianmoss
Starting Member

2 Posts

Posted - 2001-01-23 : 14:43:55

I'm in the process of converting an Access database to SQL Server 7. I have a field in Access that is of the Memo datatype. The query that routinely runs stores information in this field correctly as long as the query is run against Access. However, when I point it to the SQL Server and a field of the TEXT datatype, it always truncates some data. Any suggesstions?

Thanks!

Brian Moss
   

- Advertisement -