What exactly the problem is? What's wrong with having defaults in SQL Server?
>I have upsized a vfp database, using CA for updates, SPT everywhere else.
>
>If I set defaults for char fields in VFP, a new Default is created by Table/field name in SQL Server on upsizing, cluttering the Defaults, seems undesirable.
>
>I need to programatically set Default Values for all fields in SQL Server. Please give your suggestions.
>Thanks.
--sb--