SQL2005, ID automatically increase the field shows the value for NULL

Database switch from SQL2000 to 2005, but the data by reduction, now site data can only be read not write delete, modification, search originally found in the SQL2000 open the table after artificial add a data, ID automatically add field will automatically increase, while the 2005 is still shown as NULL, excuse me, is it right? The reason, but I check field property is not well can be empty, identify these have been selected, do not know why

Started by Bertram at November 15, 2016 - 4:01 AM

Manually add a record to have a look whether to automatically generate ID

Or try to modify the ID
alter table table_name
clumon id int identity(1,1) primary key

Posted by Wesley at November 18, 2016 - 4:16 AM

In the version switch, check all the field type and whether the property of, especially to automatically increase the identification

In the process of different versions of the translation will often have such and such differences lead to error

Posted by Murray at November 28, 2016 - 4:52 AM

Read and write permissions settings?

Posted by Dick at December 10, 2016 - 5:51 AM

Fields marked correctly. Whether the specific permissions.

Posted by Bradley at December 22, 2016 - 6:07 AM

Look at the ID field is increasing, whether [not empty]

Posted by Ian at December 27, 2016 - 6:26 AM

Improper operation. If yes, the manual is impossible to an empty record.

Posted by Rock at January 03, 2017 - 6:27 AM