>How is new table/column/constraint/sp updating to remote sites for a new version done usually:
>
>Through the programmer writing a new script that adds the new things to each site
>
>OR
>
>By using a general meta-data checker between development and production databases and then make upgrades automatically
>

I am sure both methods are employed. We use the manual method cause our users are allowed to customize the database and most change scripting tools would be destructive in this case, removing the custom columns.

BOb