HI Bruce You may need to do this in a few steps - add column, allowing nulls - update rows, setting new columns to a non-null value - alter the constraint on the new column to not null
I think that the existing rows will auotmatically try to insert null into your new column, which is set up to disallow nulls. HTH Antony On 4/14/07, Bruce Sorge <[EMAIL PROTECTED]> wrote: > > I am running this simple alter table statement: > > ALTER TABLE tblCurrentCouncilMembers ALTER COLUMN Member_ID int NOT NULL > > And the error I get is: > > Server: Msg 515, Level 16, State 2, Line 1 > Cannot insert the value NULL into column 'Member_ID', table > 'DONE_WEB.dbo.tblcurrentCouncilMembers'; column does not allow nulls. > UPDATE > fails. > The statement has been terminated. > > So can I not do this? When I run this via the database designer, I get the > message about a catastrophic failure. This is a dev SQL Server box. > > -- > Bruce Sorge > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2806 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
