May be it's a good time to follow BOL recomendations:
"CREATE DEFAULT will be removed in a future version of Microsoft SQL Server. Avoid using CREATE DEFAULT in new development work, and plan to modify applications that currently use it. Instead, use default definitions created using the DEFAULT keyword of ALTER TABLE or CREATE TABLE. For more information, see Creating and Modifying DEFAULT Definitions".
>
>I wonder if anybody could help me out here ;
>
>I have a foxpro routine which works fine under SQL server 2000, but when I run it aganst a newly installed version of SQL server 2005 Developers Edition Beta 2 I get a problem when I attempt to add a column default.
>
<snip>
--sb--