My contemplations and diurnal novelties are publicized here

SQL server Management Studio doesn’t allow the change to be done in table that need the table to be re-created.

Simple follow the following step to disable this feature:-

Go to Tools–>Options->Designers (un check the highlighted option)

Comments on: "Disabling prevent saving changes that require the table re-creation in sql server 2008" (1)

  1. Shella Mendizabal said:

    Good website, thanks for sharing this article with us.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: