saving changes to sqlserver2008
-
-
hi friends i created a database in sqlserver2008 throught management studio now i edited one of my table ie inserted a new column in it and want to save it. but it says that the changes cannot be saved so how to do it plz let me know. K.Gayathri
What else does it say about it? Is it because you have the table open in another window?
Silence is golden... but duct tape is silver!! Booger Mobile - My bright green 1964 Ford Falcon - check out the blog here!! | If you feel generous - make a donation to Camp Quality!!
-
hi friends i created a database in sqlserver2008 throught management studio now i edited one of my table ie inserted a new column in it and want to save it. but it says that the changes cannot be saved so how to do it plz let me know. K.Gayathri
It helps Microsoft support
-
hi friends i created a database in sqlserver2008 throught management studio now i edited one of my table ie inserted a new column in it and want to save it. but it says that the changes cannot be saved so how to do it plz let me know. K.Gayathri
Did you define the new column to not allow NULL ? If so, then you need to define a default value for that column.