Using SQL Server Management Studio (SSMS) for SQL 2008, I had to make a change to one of my tables to add a column. However, I did not want to add the column at the end of the table, I wanted to add the column between two other columns. When I attempted to Save the table change, I had the following error appear:
In order to resolve this issue, I had to update the following setting in SSMS. Go to Tools-->Designers-->Table and Database Designers and uncheck the "Prevent saving changes that require table re-creation" checkbox:






1 comments:
I chanced upon to view your blog and found it very interesting. Great ... Keep it up!
Post a Comment