>What exactly the problem is? What's wrong with having defaults in SQL Server?

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.