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
 Import/Export (DTS) and Replication (2000)
 recovering a text data type

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-04-01 : 08:07:35
Phil writes "Hello,

I recently did a database restore to another server, then DTSed the data from one of our servers to another. The table contained a text column. The datalength of the column seems consistent with the actual number of characters, however, when I query or export this table there is only 1 character that shows up. I'm wondering what I can do, if anything, to recover this data and see it as the full text.



Thanks,
Phil"
   

- Advertisement -