Do you want to continue attempting to save?’Ĩ) Before you click yes, make sure you won’t lose any data by making a change such as reduring the number of characters accepted or by changing the field type from say a char(255) column to a datetime one, or something simular.Īll should be working fine and as it should now. You have either made changes to a table that can’t be re-created or enabled the option prevent saving changes that require the table to be re-created.ġ) Open ‘Microsoft SQL Server Management Studio’Ģ) Click the ‘Tools’ menu and select ‘Options’ģ) Expand the column on the left title ‘Designers’ and click once on ‘Table and Database Designers’.Ĥ) Un-tick the box labelled ‘Prevent saving changes that require table re-creation’ħ) You may get a warning saying ‘Warnings were encountered during the pre-save validation process, and might result in a failure during save. The changes you have made require the following tables to be dropped and re-created.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |