problem with sql server 2008 - cant change field type

[E_Gold]

hi i have table that i want to change any field type (from int - to - varchar) i get this error: saving changes is not permitted........

[Md Marufuzzaman]

Probably you get this error while you alter your table in design mode.. If so then you need to change setting form option... set allow auto generate sql script true.. If this issue still not resolve then please let me know...:)

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

---

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. Thanks Md. Marufuzzaman

[i i i]

what are the data field sizes you are using to convert the field type you can use script as GO BEGIN ALTER TABLE tbl ALTER COLUMN [fld] [varchar](18, 8) NOT NULL END GO or create another field as varchar and update your data of numeric fld to it and then drop old column you can also use casting

Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

[E_Gold]

thank's for the help yes, i work in design mode. but, where i can find this ...option... set allow auto generate sql script true ?