How to solve the timeout problem when the field type is changed from ntext to text

天使圣翼

Change the field type from ntext to text. I have now converted all the tables with less data, but the ones with large data are wrong.

我是杀人狂

What conversion statement do you use?

zzclark

Try it like this:
Convert fields while copying with DTS
Modify the field type of the destination table in the "Column Mapping and Conversion" step

天使圣翼

Useless statement conversion directly modified in the database

121222

Conversion prompt error


"Dv_bbs1" table
-The table cannot be modified.
The timeout period has expired. The timeout period elapsed before the operation was completed or the server did not respond.

sadsadsad

You can click the option when you open it, there is a connection time setting, the default is 15 seconds