Replicating custom descriptions across multiple DB's?

ihayes@ijento.com

I have a situation where there are four different databases installed that require schema documentation.

The four different databases each have around 150 tables, and of these around 30 are common to each database.

I'm wondering is there a way I can create the common table, column and index custom descriptions once, and then reapply these common descriptions across all four databases?

Manfred.Castro

For each object, SQL Doc displays the text that is stored in the MS_Description extended property in your SQL Server database.
You could write a script that updates the extended property on the common objects and run it on all four databases.
http://sqlserverperformance.wordpress.c ... rver-2008/