by Johnny Nouel
1. abril 2011 15:21
This happened to me once and spent some time trying to find out how to make SQL Server Management Studio change the Data Type or length of a field from a table.
Let's make the following table in a Test Database and save it as "Employees".
It's a very simple table in your database and you later need to modify the length of field NAME to allow 100 characters instead of the original 50. So you go ahead and make the change and press CTRL-S. You then get the following error:
"Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created."
SSMS just stops there. It tells you what you need to do but you might not realize immediately that the fix resides in the options menu.
Go to Tools-Options in the menu. Then select from the tree in the left Designers-Table and Database Designers. Uncheck the option "Prevent saving changes that require table re-creation". Please see image below for more clarity:
Ok. Now change your table schema to your heart's content.
Cheers! 
Suscribirse