I have a situation where a client is using software that writes to a SQL table. The program has been running fine with no issues prior to today.
Today, they began receiving errors inserting NULL into the ID field. Upon going in and looking at the tables, the column "ID" which is an identity field, was set to 'NO' for "is identity".
My question is, how could this change on its own? As far as the client and I am aware, nothing has been changed recently that would cause this.
Could this happen for another reason without manually going in and changing it?