Many friends may appear when mssql modifies the database Float to decimal type and cannot modify the table. Thequeryhasbeencanceledbecausetheestimatedcostofthisquery (598) exceedstheconfiguredthresholdof300.Contactthesystemadministrator
Many friends may appear when mssql modifies the database Float to decimal type and cannot modify the table. The query has been canceled because the estimated cost of this query (598) exceeds the configured threshold of 300. Contact the system administrator. I will introduce it to you later.
Error Message
"MBom" table
-The table cannot be modified.
The query has been canceled because the estimated cost of this query (598) exceeds the configured threshold of 300. Contact the system administrator.
Solution
Right-click the modified Designer and select this option to test the content and create a new query.
Add such a sentence at the top
The Code is as follows: |
|
SET QUERY_GOVERNOR_COST_LIMIT 0; |