To add to what Jeff said, once you use the Table Designer to make changes, don't click "save".

Instead, use Table Designer | Generate Change Script or click the icon that looks like a document with a disk on it.

Save the script and discard the changes from the table designer.