NULLS can't be changed

how can i allow to edit this yellow section

[Only registered and activated users can see links. Click Here To Register...]

i know its possible throw edting desgin i guess, but i can't do it at all, need explain please, btw is that will effect anything else? and can i reback it again ? to the yellow...

thanks in advance

Quote:

Originally Posted by alydandy how can i allow to edit this yellow section [Only registered and activated users can see links. Click Here To Register...] i know its possible throw edting desgin i guess, but i can't do it at all, need explain please, btw is that will effect anything else? and can i reback it again ? to the yellow... thanks in advance

This doesnt have anything to do with the allow nulls property if that is what you meant, by the looks of it, you cannot insert whatever you want because that column has an identity increment property.

Quote:

Originally Posted by Isoline* This doesnt have anything to do with the allow nulls property if that is what you meant, by the looks of it, you cannot insert whatever you want because that column has an identity increment property.

thanks for ur answer i really apprecaite it,

some1 joined my pc before to help me for something, and he did something that allowed him to change numbers in that Yellow Section, and i remember that thing he did was in Desgin
[Only registered and activated users can see links. Click Here To Register...]

i just can't remember what exactly he did...

As Isoline said, this isn't related to NULL, this is just a IDENTITY_INSERT property. Just set it off. Visit [Only registered and activated users can see links. Click Here To Register...], if you don't know how.

Quote:

Originally Posted by #HB As Isoline said, this isn't related to NULL, this is just a IDENTITY_INSERT property. Just set it off. Visit [Only registered and activated users can see links. Click Here To Register...], if you don't know how.

[Only registered and activated users can see links. Click Here To Register...]

i did that and i clicked on save, then i refreshed the tab and still not change able
so what should i do ? please explain more...

Quote:

Originally Posted by alydandy [Only registered and activated users can see links. Click Here To Register...] i did that and i clicked on save, then i refreshed the tab and still not change able so what should i do ? please explain more...

This problem occurs when the Prevent saving changes that require the table re-creation option is enabled, and you make one or more of the following changes to the table:
You change the Allow Nulls setting for a column.
You reorder columns in the table.
You change the column data type.
You add a new column.
[Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by alydandy [Only registered and activated users can see links. Click Here To Register...] i did that and i clicked on save, then i refreshed the tab and still not change able so what should i do ? please explain more...

I dont know what you are trying to accomplish here, but i would not advise you to edit the these stuff, it is a very delicate buisness, there is a reason for the incremental identity property, by looking at the picture you have uploaded, _Char table is definitely not a table to be messed around with, it is dependent on many objects in the database & vice versa, you will screw up your database.

Quote:

Originally Posted by mialuisa This problem occurs when the Prevent saving changes that require the table re-creation option is enabled, and you make one or more of the following changes to the table: You change the Allow Nulls setting for a column. You reorder columns in the table. You change the column data type. You add a new column. [Only registered and activated users can see links. Click Here To Register...]

that's it it working now perfectly, thanks sir i really apprecaite it <3

but i wonder, i pressed yes on both so i can continue is that will effect anything ? i mean is that normally ?
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

thanks in advance.

Quote:

Originally Posted by alydandy that's it it working now perfectly, thanks sir i really apprecaite it <3 but i wonder, i pressed yes on both so i can continue is that will effect anything ? i mean is that normally ? [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] thanks in advance.

its normal yes you can continue idk if any effect i was change it also
if i close identy after my edits i change it back

Quote:

Originally Posted by mialuisa its normal yes you can continue idk if any effect i was change it also if i close identy after my edits i change it back

thanks you make me feel comfortable now,
thanks to everyone tried to help me <3, wish the best for you guys in ur projects & dreams...
Problem Solved.