Hi
Anyone than knows how to change the collation name for a
database. Or can you only do that when you create a new
one??

/Anett

Whilst this is not strictly DTS have a look at this in BOL

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\architec.chm::/8_ar_da_819v.htm


Particularly

"After a collation has been assigned to any object other than a column
or database, you cannot change the collation except by dropping and
re-creating the object. This can be a complex operation. To change the
default collation for an instance of MicrosoftR SQL ServerT 2000 you
must:....."





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