Database field type conversion problem

121222

In the mssql enterprise manager, I want to convert the field type in the database DV_bbs table from ntext to text, but an error occurred during the conversion.
There are about 400,000 pieces of data in the table. Prompt that the server has timed out, and tables with less test data can be converted.
Please help from a master.

苹果小刀

Set a longer timeout
The properties of the database!

苹果小刀

It is recommended to use alter table statement processing!

121222

Where is the sql server timeout set?

121222

Has anyone encountered it?

天风鲁伊

How long will it take?

摩羯可乐

In the Query Analyzer-the upper drop-down menu (tools)-options-connection (just set the timeout period)

天风鲁伊

You right-click on one of the registrations in the enterprise manager, properties, and then click the connection page in the SQL properties, there is a timeout setting

天风鲁伊

Right-click the property on the triangle icon that displays the running status, and the SQL property will pop up

lone_lau

untested.