You can bind defaults using sp_bindefault stored procedure but it's depricated and will be removed in a future version of SQL Server. It's recomended to add DEFAULT constrains using CREATE/ALTER TABLE

-- Unnamed, SQL Server will generate name
ALTER TABLE mytable
ADD 
DEFAULT ('')
FOR mycolumn
-- named
ALTER TABLE mytable
ADD 
CONSTRAINT whatever 
DEFAULT ('')
FOR mycolumn

>See all the 0 Defaults are shown in defaults as UW_ZeroDefault whereas String Defaults of " " are being converted as table/field name (e.g. Dflt_acbal_sess, Dflt_acbal_accnum) for each field. I could have created a single default as
>
>

>USE [au4]
>GO
>CREATE DEFAULT [dbo].[Dflt_SpaceDefault] AS ''
>

>
>I could have applied thew same default in all fields. Also I need to apply defaults to all the fields programatically and not manually one by one.