My question is simple, yet I can’t seem to find any help on it. I cannot add records to any of the tables in my SQL database. All the login permissions are set to allow me to do it, but the tables still remain un-updatable.
Is the database in read-only mode? Is this database a replication subscriber? How are you trying to accomplish the update?
Update mytable set mycolumn to mynewval where myoldval=x
Sorry I couldn’t be more helpful.