Database collation

Hello,
I have database migrated from SQL7 to SQL2K.
This database has collation 'comaptibility something bla bla'.
Other database4s located at this server has different collation name,
because were created under SQL2K. PRoblem is when I try to join tabels
between old database and new.
Is it possible to change this collation to another (from SQL2K) ?
--
Best Regards,
IksHi
It looks like you have collation compatibility problems.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_8uer.asp
To change collations check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_819v.asp
http://tinyurl.com/ky3q
"Iks" <jko74__usun__@.wp.pl> wrote in message
news:bi7igc$mol$1@.atlantis.news.tpi.pl...
> Hello,
> I have database migrated from SQL7 to SQL2K.
> This database has collation 'comaptibility something bla bla'.
> Other database4s located at this server has different collation name,
> because were created under SQL2K. PRoblem is when I try to join tabels
> between old database and new.
> Is it possible to change this collation to another (from SQL2K) ?
> --
> Best Regards,
> Iks
>|||Hi,
I'm not sure about that, but I think that the collations
you are trying to join are not compatible - why don't you
try to identify a collation that is equivalent from this
using in the database migrated from sql 7 and change the
collation for that specific column, i've never seen an
option that changes all collations from database at time !
Only in the installation you specify a collation that is
going to be used for the new created databases.
Sorry if Couldn't help you !
>--Original Message--
>Uzytkownik "Roberto Carrasco" <roberto_carrasco@.msn.com>
napisal w
>wiadomosci news:090701c36981$b03d9770$a301280a@.phx.gbl...
>> Hi,
>> If I understand your question --Yes SQLserver2000 Allows
>> you to have differente collation for database even to
>> columns !
>Yes, I know. But at this time I have on my server one
database
>(migrated from SQL7) with old-style collation. Other
databases
>were created with new default server collation.
>There is no problem until I have to compare two columns
from
>different databases (different collations) - join tables
from different
>databases.
>That's the reason I would like to unify collation for all
databases
>located on this server.
>--
>regards,
>Iks
>
>.
>