SQL Serever 2008 ALTER TABLE Problem

Question

hi i had this problem when i was trying to modify the identity of a a field in a table Named TestTablei tried to modify it from the object explorer but it didn't Save my changes : (Saving changes is not permittedetc) 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 );

Manish Dwivedi · Answer

Hi Maro 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.

Crish · Answer

This is more useful answer

Morcos Adel · Answer

Dear Manish thank you very much for your concerns

Morcos Adel · Answer

Arshad Thank you very much i tried it and it works..Thank again Best Regards Maro

Arshad · Answer

Hi 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