3

I'm using SQL Server 2008, I have created the database and the table with Microsoft SQL Server Management Studio.

Every time I make any changes in the columns or in the inserted records it shows an alert message says "saving changes is not permitted......."

I seriously need your help <3

thank you

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
F 505
  • 404
  • 3
  • 10
  • 18

1 Answers1

5

By default SQL Server Management Studio prevents you from running scripts that will require you to drop and re-create the table, which includes modifications to the columns. You can turn that dialog off in the options:

Tools -> Options -> Designers

Uncheck "Prevent saving changes that require table re-creation." Hit Ok.

And then try again.

Praveen
  • 55,303
  • 33
  • 133
  • 164
Kyle Hale
  • 7,912
  • 1
  • 37
  • 58
  • I answered this before it was pointed out this was a duplicate. If it's closed a duplicate, will this answer be deleted automatically? If not, could someone do that? Thanks. – Kyle Hale Nov 06 '13 at 15:30
  • No problem, it won't affect you. Better leave it as answer. Moderators will take care :) – Praveen Nov 06 '13 at 15:32