How to set the setting in Management Studio 2008R2

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

i was already created table this table some data after that i change the desing: i got
this error. how set the settings Management studio 2008R2

I got this Error

Saving changes is not permitted. The changes you have made require the following table
to be droped and re-created. 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 re-created

Posted 15-Jun-12 0:39am

2011999

Updated 15-Jun-12 0:40am

v2

Add a Solution

2 solutions

Solution 1

in SQL Server 2008, if you want to change something then you have to do with SQL query only. At first sight it seems visible that we can perform on GUI, but we can't do that.

Posted 15-Jun-12 0:45am

Farhan Ghumra

Comments

Manas Bhardwaj 15-Jun-12 6:53am

I don't think that's true!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manas Bhardwaj · Accepted Answer · 2012-06-15T00:52:00

Solution 2

You should have googled with the error message.

LMGTFY[^]

The first link itself gives the answer:

http://support.microsoft.com/kb/956176[^]

To change the Prevent saving changes that require the table re-creation option, follow these steps:
1.Open SQL Server Management Studio (SSMS).
2.On the Tools menu, click Options.
3.In the navigation pane of the Options window, click Designers.
4.Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.

Posted 15-Jun-12 0:52am

Manas Bhardwaj

Comments

Espen Harlinn 15-Jun-12 8:31am

5'ed!

Manas Bhardwaj 15-Jun-12 8:45am

thx!

Sandeep Mewara 15-Jun-12 11:51am

Good answer. 5!

Manas Bhardwaj 15-Jun-12 17:08pm

thx!