You should be able to get that info from the information_schema.columns view. Check it out in the BOL, specifically the COLUMN_DEFAULT column.

-Mike


>Anyone know an easy way to list all tables/fields that have getdate() as the default value. I now looking a central hosting version of our application with users from 3 time zones, another thing I should have thought of up front.
>
>Thanks for any tips
>
>Kirk