Sql 2008 with Mgmt Studio 2008

Discussion in 'Databases' started by Kdc31, Feb 5, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Kdc31

    Kdc31

    I create a table using the Sql Server Mgmt Studio 2008 for my 2008 db on discountasp.net. When I try to make a modification (adding another column), I get an error message in the attached file.

    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.

    Any thoughts? The only thing different than any other attempts was that this new table is using a different schema. Perhaps that is throwing me off?

    Thanks in advance,

    Kevin
     
    Kdc31, Feb 5, 2010
    #1
  2. dmitri

    dmitri DiscountASP.NET Staff

    You probably created Database Diagrams, added your tables to it, and tried to modify and save changes directly from there. By default, Management Studio prevents you from saving changes to the underlined tables from Database Diagrams if that requires dropping and re-creating the tables.

    If you want to enable this option, go to Tools / Options, navigate to Designers / Table and Database Designers, and un-check "Prevent saving changes that require table re-creation."
     
    dmitri, Feb 5, 2010
    #2
  3. JorgeR

    JorgeR DiscountASP.NET Staff

    This is by design for SSMS. You will need to go to options of SSMS -
    Designers –> Table and Database Designers, uncheck the box - Prevent saving changes that require table re-creation option
     
    JorgeR, Feb 9, 2010
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page