In a database I made some diagrams. In the table view I added the custom
column "decription" so I could descibe every field of the table

This works perfect.

Now I want to copy these diagrams to another database.
I used DTS with "Use a query" to put all info from dtproperties in new
database.

This works fine, except the custom column "description" is there, but it is
empty.

How do I fix this?

assuming you are using sql2k, in the dts wizard select 'Copy objects and
data between sql server databases'. In the next window check 'Include
extended properties'. this will copy the properties you are looking for.
when you are done running the dts, you need to come back and do the process
you are talking about to import the daigrams from dtprops


"Johan" <Johan (AT) discussions (DOT) microsoft.com> wrote

Yes, I'm using sql2000.

So I can uncheck all the other options and only copy the Extented properties?

"moondaddy" wrote: