Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

sql server 2008, stored procedure

Posted on 2013-10-23
2
Medium Priority
?
270 Views
Last Modified: 2013-11-27
sir i have created one table (degree master) as below in sql server 2008

degreeid  int(identity) PK
degree name varchar(50)

i have few records of data in this table and this table has relationship with two more table (program master and faculty master).

now i want to add a new field to this degree master table after degreeid field.

i.e.
degreeid int(identity)PK
degreetype varchar(50)
degreename varchar(50).

after adding this field when i try to save this table it gives me error and suggest to drop and re-create table again. I also tried it after removing relationship with other two table but still it gives me the same error and suggest me to drop and create table again  which i dont want to do.

Is there any other ways to do so.

thanks
ronak
0
Comment
Question by:ronipats
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 34

Expert Comment

by:Brian Crowe
ID: 39596333
If you are inserting a column, as opposed to just adding it to the end, then you have no choice but to drop and recreate the table.  This is typically handled automatically after a warning prompt from SSMS.  However, there is a default setting that will prevent this action from occurring.  To enable the change...

Go into Tools -> Options -> Designers-> Uncheck "Prevent saving changes that require table re-creation"
0
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 1500 total points
ID: 39596336
0

Featured Post

Use Filtering Commands to Process Files in Linux

Learn how to manipulate data with the help of various filtering commands such as `cat`, `fmt`, `pr`, and others in Linux.

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

705 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