>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.
Thanks. I will write a script to traverse all fields in all table except PK to set the defaults.
Aman
-------
Lets fly away to the Land where there is Love & Peace