可能很多朋友在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; |
|
