Permission to save database

Question

Possible Duplicate:
Saving changes after table edit in SQL Server Management Studio

I need to make changes in a already made database, but SQL is refusing my request. Something about preventing changes that require the table to be re-created??

What to do?

We need to see the error message to help us better understand your problem. — Trey Copeland, Mar 21 '12 at 19:22
What changes? What errors? Show us your code and error messages. — Joe Stefanelli, Mar 21 '12 at 19:25
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. — Erik Lindbøg-Løfgreen, Mar 21 '12 at 19:27

score 2 · Accepted Answer · answered Mar 21 '12 at 19:31

2

This is an option in sql server management studio. It is not a permission issue.

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.

answered Mar 21 '12 at 19:31

Russell Hart

1,842
13
20

Sorry 2 bother u sir. Can i ask u another question or shall I write again? – Erik Lindbøg-Løfgreen Mar 21 '12 at 19:41
Best to ask another question if it is a separate problem. You can add a link to this 1 if it is related. – Russell Hart Mar 21 '12 at 19:43

score 0 · Answer 2 · edited Jun 06 '17 at 15:21

0

Sounds like you've run into the following error when trying to alter a table structure via SSMS...

enter image description here

This is just a safety precaution in SSMS...read this article to learn how to disable it. Or better yet, manually script out the DDL changes in TSQL and add in some error-handling and reverse-changes logic.

edited Jun 06 '17 at 15:21

WonderWorker

8,539
4
63
74

answered Mar 21 '12 at 19:33

Bill Anton

2,920
17
23

Permission to save database

2 Answers2