I have inherited a database, and have found a bit of a flaw that is preventing me from updating it. Let me first start by saying I know a little about SQL, but mainly from access, and a few searches here and there.
The problem is that the primary key (for office codes) was set to a length of 5 chars. We have merged with a new company, and the office naming convention is 6 chars long. I want to set it to 10 chars, just to be safe. I am in SQL Server Management Studio, and can see the table, but I cannot make changes to it. When I try it gives this error:
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Preventing saving changes that require the table to be re-created.
I can (it seems) to remove the PK marker from that column, and save, and it seems to be ok with that, but after that, I still cannot change the length of the column. This database is not in constant use, and I can cut the end users off from it for a day. I just don’t want to wreck the database in trying to get these changes made.