Hi Naomi,

I think you have to put them in separate ALTER TABLE commands. I'm pretty sure that you can't have multiple ALTER COLUMNs in one statement.

~~Bonnie




>>Hi everybody,
>>
>>I'm trying to change nullability of multiple columns at once and can not get the syntax right.
>>
>>Would you help please?
>>
>>alter table Student_Registration ALTER COLUMN sID int NOT NULL ALTER COLUMN TermID int NOT NULL
>>
>>
>>Thanks in advance.
>
>Tried to google and still could not find the correct syntax.