Hello Martin,

Thanks for your reply. Unfortunately, I had already tried that syntax and it does not appear to "drop" the existing default value on the column, at least it doesn't here using SQL Server 2000 (at the latest SP).


Angie.