Set a existing column of MS SQL table as NOT NULL

ALTER TABLE tablename
ALTER COLUMN columnname datatype NOT NULL

You will obviously have to make sure that the column does not contain any NULL values before doing this.

E.g.

ALTER TABLE orders
ALTER COLUMN customer_id INT NOT NULL