Saving changes is not permitted in SQL 2008 Management Studio

I worked with SQL 2008 in a recent project, but I got the following message whenever I try to make change to a table structure in SQL management studio:

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

I used to write ALTER statement (e.g. ALTER Table.. .ALTER Column...) so I don't really know what is the error message mean. Today, I search it during my Xmas holiday and know that there's a option in Tools | Options | Designer | Prevent saving change that require table re-creation.

Uncheck it and then I can modify table structure in GUI now. :)

Regards,
Colt

Published Saturday, December 26, 2009 6:30 PM by Colt
Filed under:

Comments

# re: Saving changes is not permitted in SQL 2008 Management Studio

Thanks for info, this default setting is annoying.

Saturday, December 26, 2009 9:30 AM by Pradeep

# re: Saving changes is not permitted in SQL 2008 Management Studio

And if you have it create the script, you will see that the table is being created anew, and the data is being moved over (if the conversion is implicit).  One reason for the checkbox is that there are non-implicit conversions you have create that would save data if you were to do it yourself, so it serves as a warning.  It would perhaps be more helpful if it threw up a "do you want to" dialog, rather than just prevented the action.

Sunday, December 27, 2009 8:49 PM by Hank Fay

# re: Saving changes is not permitted in SQL 2008 Management Studio

RE: Hank

Exactly, that's what I want too.

(A follow up question would be "Why do I face XX in SQL 2008 but not SQL 2005? huh?" :)

Monday, December 28, 2009 11:29 PM by Colt

# re: Saving changes is not permitted in SQL 2008 Management Studio

Saved our time, thank you.

Thursday, January 07, 2010 2:50 PM by Ram

# re: Saving changes is not permitted in SQL 2008 Management Studio

<a href="allergy-dr.com/tavist.htm">tavist generic</a>

Monday, March 15, 2010 3:53 PM by HsvsRsvsesv

# re: Saving changes is not permitted in SQL 2008 Management Studio

thanks a lot - saved my time :)

Tuesday, April 06, 2010 2:07 AM by Fiorina

# re: Saving changes is not permitted in SQL 2008 Management Studio

its working..

thnks.

Thursday, April 29, 2010 3:24 AM by GKS

# re: Saving changes is not permitted in SQL 2008 Management Studio

thanks man u saved my (job)

Allah tumko hidiyat dee ..

Say aameen..

Wednesday, June 23, 2010 5:31 AM by irfi...

# re: Saving changes is not permitted in SQL 2008 Management Studio

Hi, Thanks. Its valuable blog.

Sunday, June 27, 2010 9:49 AM by Haresh Ambaliya

# re: Saving changes is not permitted in SQL 2008 Management Studio

It is certainly interesting for me to read the article. Thank author for it. I like such themes and everything that is connected to them. I would like to read more on that site soon. BTW, rather good design this blog has, but don’t you think design should be changed every few months?

Kate  Meetington

<a href="www.baccaratgirls.com/">escort latina</a>

Tuesday, September 07, 2010 7:12 AM by Kate Meetington

# re: Saving changes is not permitted in SQL 2008 Management Studio

Thanks a lot dude! That error ws begginin to gt on Ma Nerves!

Thursday, September 09, 2010 4:28 AM by Svig Ntwane'Strongo

# re: Saving changes is not permitted in SQL 2008 Management Studio

thanks dude .. good information

Sunday, September 26, 2010 11:13 AM by srikant

# re: Saving changes is not permitted in SQL 2008 Management Studio

Damn, truly great post. Where will I find your RSS?

Whitny  Swingfield

<a href="www.wirelesscameradetectors.com/">spy security</a>

Thursday, November 11, 2010 5:00 AM by Whitny Swingfield

# re: Saving changes is not permitted in SQL 2008 Management Studio

thanks. Its working now

Wednesday, December 22, 2010 1:27 AM by Sudhir

# SQL Server : saving change is not permitted??? - Programmers Goodies

Pingback from  SQL Server : saving change is not permitted??? - Programmers Goodies

# re: Saving changes is not permitted in SQL 2008 Management Studio

Thanks a lot.. It saved lot of my time.

Thursday, July 28, 2011 10:48 PM by Gomathy

# re: Saving changes is not permitted in SQL 2008 Management Studio

Yes there should realize the opportunity to RSS commentary, quite simply, CMS is another on the blog.

Sunday, August 28, 2011 8:11 AM by tryecrot

# re: Saving changes is not permitted in SQL 2008 Management Studio

Доброго времени суток,  

Хочу представить вам прозелит магазин курительных смесей

сайт магазина http://spice-family.ru  

3г микса Moderate - 1,500 р. + доставка (ems, pony set)  

По вопросам опта чертить отдельно в скайп - FomaX2

Friday, September 02, 2011 9:22 PM by Pupeevetlylit

# re: Saving changes is not permitted in SQL 2008 Management Studio

Thank u. thats work

Friday, October 07, 2011 10:16 PM by Vishal

# Saving change is not permitted in SQL Server - Programmers Goodies

Pingback from  Saving change is not permitted in SQL Server - Programmers Goodies

# re: Saving changes is not permitted in SQL 2008 Management Studio

Thanks ...

it really helped... !!!

Wednesday, December 14, 2011 11:00 AM by GS

# re: Saving changes is not permitted in SQL 2008 Management Studio

to provide additional guidancea

Tuesday, January 31, 2012 12:09 PM by nodeFedEpoere

# re: Saving changes is not permitted in SQL 2008 Management Studio

На какие подкатегории стоит поделить Юмор?    

<a href=http://xn--c1aeb8eua.xn--p1ai/>обрезание мальчиков картинки</a>

Wednesday, February 01, 2012 8:02 AM by ReageasencyuI

# Saving changes is not permitted in SQL 2008 Management Studio &laquo; ???? ????????

Pingback from  Saving changes is not permitted in SQL 2008 Management Studio &laquo; ???? ????????

# re: Saving changes is not permitted in SQL 2008 Management Studio

thanks its really helpfull for all

Friday, February 17, 2012 5:11 AM by simha

# re: Saving changes is not permitted in SQL 2008 Management Studio

Thanks for info ...

Thursday, March 08, 2012 2:33 AM by Chaminda

# re: Saving changes is not permitted in SQL 2008 Management Studio

Thanks a lot, it helps!

Monday, April 02, 2012 8:25 AM by pvo

# re: Saving changes is not permitted in SQL 2008 Management Studio

thnks ...that is exactly wat i want....

Friday, April 20, 2012 6:57 AM by twangchuk

# re: Saving changes is not permitted in SQL 2008 Management Studio

thanks man

cheers!!!

Tuesday, April 24, 2012 9:44 AM by amol

# re: Saving changes is not permitted in SQL 2008 Management Studio

Thanks Alot for your efforts ;)

Friday, May 11, 2012 12:25 PM by Mohamed Safwat

Leave a Comment

(required) 
(required) 
(optional)
(required)