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 |
|
anujpratap84
Starting Member
45 Posts |
 Posted - 2010-11-25 : 05:19:42
|
| Hi All,I am always found issue when i update the table structure.It's showing message. "Saving changes is not permitted. The Changes u have made require the following table to be dropped and recreated. You have either......Why this problem occurs every time?Any body have any idea.Thanks in advance.Anuj Pratap Singh |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-25 : 05:28:34
|
| It's just a protection in management studio to protect you from doing something you hadn't planned for.I would script the changes, check them and run in a query window.To alow ittools, options, table and database designersclear prevent saving changes that require table re-creation.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-25 : 05:41:11
|
| Thanx a lot dude.i was also facing the same problem. |
|
|
|
anujpratap84
Starting Member
45 Posts |
Posted - 2010-12-07 : 06:07:04
|
quote:
Originally posted by nigelrivett
It's just a protection in management studio to protect you from doing something you hadn't planned for.I would script the changes, check them and run in a query window.To alow ittools, options, table and database designersclear prevent saving changes that require table re-creation.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy.
Thank you dear!!Anuj Pratap Singh |
|
|
|
|
|
|
Problem in updating table structure