i had this problem when i was trying to modify the identity of a a field in a table Named TestTable,i tried to modify it from the object explorer but it didn't Save my changes :
(Saving changes is not permitted,etc)
i tried to write a sql statement to alter my table but it is not working...
Satement i am using :
ALTER
ANY Help ???
TABLE TestTable ALTER COLUMN id IDENTITY (1,1);
Blocked AccountPosted Apr 12, 2011, 5:14 AM
try this solution
go to object explorer and make the necessary changes in the table.
and befor saving the table Click on Tools and select Option, you will get the Option dialog box as in the image below
Unchecked the marked checkbox.
after that save the table.
CrishPosted Apr 13, 2011, 8:19 AM
Morcos AdelPosted Apr 12, 2011, 5:33 AM
thank you very much for your concerns
Morcos AdelPosted Apr 12, 2011, 5:13 AM
Best Regards
Maro
ArshadPosted Apr 12, 2011, 5:05 AM
you can disable one option from the SQL Management Studio.
Menu >> Tools >> Options >> Designers >> Uncheck "Prevent Saving changes that require table re-creation".
Just uncheck this option from the above path under the management studio. it will work
Regards,
Arshad