error: Column already has a DEFAULT bound to it.
Posted on 2006-05-16
Good afternoon Experts
We are attempting to update a default value that is a date. when we attempt to alter this default value we get the following error.
Server: Msg 1781, Level 16, State 1, Line 1
Column already has a DEFAULT bound to it.
Server: Msg 1750, Level 16, State 1, Line 1
Could not create constraint. See previous errors.
I read that this problem is caused when trying to update a default value that is all ready a date/time to a different date/time. But I did not find a fix for it.
Anyone run into this problem before and have a solution to how we can alter this default value?