July 13, 2011 at 12:09 am
Hi,
what could be reason alter table column not working through GUID in ssms?
But query editor by using ALTER TABLE <tablename> ALTER COLUMN VARCHAR(100) - Its working.
Pl tell me, why table design proerties not working in SSMS?
Rgds
aananda
July 13, 2011 at 12:17 am
It all depends on what you mean by "not working". Do you get a specific error message, does it time out or what?
Best guess is the change you are making is one that SSMS handles by droppping and re-creating the table, this can be time consuming anmd so that option is disabled by default.
MIke
July 14, 2011 at 12:09 am
the error text I get is:
"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"
pretty basic table, four fields - no PK's\FK's\indexes etc. The change I tried to make was to alter one field from nvarchar(10) to nvarchar(20)
This really isn't an problem for me - as the original poster stated, it works fine if you use the ALTER TABLE statement in T-SQL
but I have seen the error before and thought I would reply.
LDK
July 14, 2011 at 6:14 am
July 14, 2011 at 6:20 am
Basic idea is that this is to stop all changes that can cause the server to hang (because they would take tones of ressources).
It's not a bad idea to keep that setting on unless you know that server reallllllllly well.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy