Thing is I found when I insert a table, prompt to insert the success, but the data into database, took a long time to find the reason, because this table in the database to automatically generate a field in the "statistics", lead to problems, I delete the statistical information, can normal operation of inserting data, but the table will automatically generate "statistics", unable to solve my problem, check the information only stopped the entire database Settings, this is not acceptable, there is no other solution, please?

CodePudding user response:

In fact the main is to want to solve the problems of the normal can insert data, is there not operation "statistics" on the way?

CodePudding user response:

Excuse me, can you provide the SQL script to recreate this question?

CodePudding user response:

Please check the SQL2005 SP4 patch is installed.

CodePudding user response:

Mobile phone option to automatically generate and update statistics try set to false

CodePudding user response:

Delete statistics is just a temporary solution, the root cause hasn't been solved, and what is error