Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
michael999
Starting Member
9 Posts |
 Posted - 2011-12-04 : 17:12:53
|
| hiI have a database with several tables. But one is not allowing me to make changes to it.The website is returningCannot insert the value NULL into column 'CustomerID', table 'xxxxxxxx.Customers'; column does not allow nulls. INSERT fails.But the problem is with one table on the database. It was working OK but somehow the table settings changed.The Identity specification is now set to No. I can change the settings to Yes and set is identity = Yes and I cannot save the changes.I am supposed to be able to do it if I drop and recreate the tables!!What do I need to do to sort this out please?Michael |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
database table problem