mssql修改数据库Float到decimal类型无法修改表

可能很多朋友在mssql修改数据库Float到decimal类型时就会出现, 无法修改表。 The query has been canceled because the estimated cost of this query (598) exceeds the configured threshold of 300. Contact the system administrator,了下面我来给各位介

错误提示

“MBom”表
- 无法修改表。
The query has been canceled because the estimated cost of this query (598) exceeds the configured threshold of 300. Contact the system administrator.

解决办法

在修改后的Designer上右键，选这个，把内容考出来，新建一个查询

在最上面加这么一句

代码如下	复制代码
SET QUERY_GOVERNOR_COST_LIMIT 0;