SQL 2008 SSMS Table Save Error

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:

SSMS_Table_Save_Error

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:

SSMS_Table_Designer_Option

1 comments:

Smith said...

I chanced upon to view your blog and found it very interesting. Great ... Keep it up!