Why can't I save my newly created database diagram???

Question

Why can't I save my newly created database diagram???

sunyanworld

SSC-Addicted

Points: 406
More actions
May 31, 2012 at 4:48 pm

#392404

Hi guys,
I have several tables ready in SQL server, and now I am trying to build relationships between them. I am trying to do so through the 'database' diagram. I was able to set primary keys and build the relationships, but when I tried to save the diagram, an error kept popping out, saying '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.' What should I do??
Thank you so much!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sunyanworld SSC-Addicted Points: 406 More actions · Answer 1

Oh I just found that the server doesn't allow me to make any changes to the tables I created, either. The same error comes out when I tried to change my tables:

'Saving changes is not permitted.....'

What is going on???:angry:

sunyanworld SSC-Addicted Points: 406 More actions · Answer 2

haha, found the answer:

'http://techierambles.blogspot.com/2010/03/cant-save-table-design-changes-in-sql.html'

Jeff Moden SSC Guru Points: 1004683 More actions · Answer 3

BWAAA-HAAAA!!!! The first time I ran into that problem, I almost unbolted it an threw it through a window. I mean really... I've heard of security enhancements but who would actually make such a thing a default with no warning until it was too late?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sunyanworld SSC-Addicted Points: 406 More actions · Answer 4

Totally agree!!!! They should at least be more specific in the error message letting users know where to change the 'default' setting, which REALLY should not be set as default.

Jeff Moden (5/31/2012)
BWAAA-HAAAA!!!! The first time I ran into that problem, I almost unbolted it an threw it through a window. I mean really... I've heard of security enhancements but who would actually make such a thing a default with no warning until it was too late?