Manoj Bhatt Total Post:154 Points:1086 Posted by Manoj Bhatt May-06-2013 1:52 AM MSSQL Server MSSQL Server 1 Reply(s) 2116 View(s) Ratings: Rate this: Hi Everyone! I already have a table which consists of data. I need to alter table to add two new columns which are not null. How can I do that without losing any existing data? Here's what I tried (via right-clicking the table and selecting Design): Added new columns 'EmpFlag' (bit, null), 'CreatedDate' (datetime, null) Updated 'EmpFlag' column in the table, to have some valid values. (Just wanted to work on one field, so I didn't update 'CreatedDate' field) Now right clicked table, design, and made it not null. When I tried to save, this error message appeared: Thanks in advance!