When i transfer data between two databases, some table properties hasn't been copied, like the "default" value of the table. Then, when the users insert data into the table, the columns with blank values, are marked as NULL and the application bypass rows that have NULL values.
I alter the default values for some tables in Sql Enterprise Manager, but not all 'cause i don't which tables must be altered.
How can i search my database for the table properties of ALL tables, looking for the "Default Value" property not filled ?
p.s. Sorry for my english, i'm brazilian... i hope u understand.