Solved

Trouble creating new field on table

Posted on 2013-06-11
4
199 Views
Last Modified: 2013-06-14
I'm trying to insert a new field into a table and I'm getting the following error:

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.
0
Comment
Question by:hrolsons
  • 3
4 Comments
 
LVL 11

Expert Comment

by:Louis01
ID: 39239530
In SQL Server Management Studio, go to Tools, Options, [Designers, Table and Database designers]. Remove the checkbox against [Prevent saving changes that require table re-creation]

Keep in mind that you can loose all data in the table. In such cases, it is frequently a good idea to rename the table, recreate it and import the data.
0
 

Author Comment

by:hrolsons
ID: 39239548
I would rather do it the safe way.  I can handle renaming.  Recreate, would that be Script-Create To and add my new field into the SQL.  And then I'm not sure how to import.
0
 
LVL 11

Accepted Solution

by:
Louis01 earned 500 total points
ID: 39239582
You could right click on the table name in Object Explorer and generate a new create script from there to alter.

To import, see INSERT INTO SELECT FROM

If your simply want to add a new column to a table, consider that you are probably specifying it as NOT NULL, thus the recreating of the table. Maybe you can set it as NULLABLE initially, set some value and then make it NOT NULLABLE.

For help on Alter Table Scripts, see ALTER TABLE
0
 
LVL 11

Expert Comment

by:Louis01
ID: 39246714
hrolsons

Did you manage?

Louis
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question