By default SQL Server Management Studio does not allow changes to be made to tables if they need to be dropped and recreated. This is frustrating in a development environment since changes are made quite often. Again, Microsoft enables a feature to protect a production environment and does not make a fix for it well known. Here is the error you will receive:
Here is the fix… go to “Tools > Options”:
Then expand “Designers” then click on “Table and Database Designers”. Uncheck the box next to “Prevent saving changes that require table re-creation”:
0 comments:
Post a Comment