Thank this author by sharing:
By Michael Søndergaard,
Run the script on the database, where you wishes to convert default objects to columns defaults. This will generated sql statements, which you can execute.
Remember to read the file header for more information
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.