Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leewilmos
Starting Member
2 Posts |
 Posted - 2009-06-19 : 09:51:26
|
| Dear all prof,I just upgraded to the latest 2008 server this week. But i found that is too much different and difficult while editing the columns in table.In 2005 version, I can right click on the table, choose Design option, then i can do whatever changes i want to the columns like change the null to not null, move up and down the colums, or rename the column name. But in SQL 2008, I can't do this at all, everytime i make changes and try to save it , I will encounter this error below:Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created............This make very uneffective where i need to drop and recreate the whole table everytime for just a small modification work..Is this a new security features in SQL 2008? Any idea to make the modification work more friendly without recreate the table or using sp?Thanks in adv.Regards,Wilmos Lee. |
|
|
leewilmos
Starting Member
2 Posts |
Posted - 2009-06-19 : 11:04:55
|
| I hv found the solution. Tool -> Options -> Designers -> Table and Database designers -> uncheck the option "Prevent saving changes tht require table re-creation".Thks. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-20 : 02:39:51
|
| why are you using designer for all these? it would be better to start using DDL statements for these like CREATE TABLE,ALTER TABLE,... |
|
|
|
Wilmos
Starting Member
13 Posts |
Posted - 2009-06-23 : 14:06:14
|
| sure visakh16, I will start practicing it. just sometime feel the designer more easier that writing code manully,, ya.. admit tht i am bit lazy sometimes,, hee..thks. |
|
|
|
|
|
|
|
|
How to Edit Column in MS SQL SERVER 2008