This solution needs to work for SQL 2000 and 2005.
I walked into a DB that has many nullable bit fields that have no default value. I want to iterate each table (programatically in SQL) and for each bit field:
1. add the constraint of not null
2. add the default value of 0 (zero)
I don't know the system objects well enough to do this myself. The only gotcha that I can see is how to handle tables that are already populated. If you are an expert and see a flaw in what I'm trying to do, please let me know.