"Eureca" <anonymous@discussions.microsoft.com> wrote in message
news:1192901c3bfbe$1b5bd340$a601280a@phx.gbl...
> Hi, I have to import a database in SQL 7.0 Service Pack 4
> from which I have the *.mdf and *.ldf files in a new
> server. The problem I get when I do "sp_attach_db" is:
>
> "Server: mesagge 1816, level 16, state 1, line 1
> Cannot attach db due to the difference in Character Set,
> Sort Order or Unicode intercalation.
>
> Warning: Unicode language locale 1033 from the db is
> different than the server Unicode language locale, 1034.
> Warning: Unicode language locale 1033 from the db is
> different from the Server, Unicode language locale de 1034.
>
> If I make a new instal of the SQL 7 Server and I choose
> the Default or Typical setup I get the Server installed
> with Locale 1033 but I find that it install the sort order
> as ISO character set and this also differs from the db I
> have so I need "850 Multilingual Character Set" and NOT
> ISO-Character Set.
>
> Any explanation for this/way to solve it? Maybe installing
> SQl 2000 and trying to upgrade db?
>
> Thanks in advance
>

>-----Original Message-----
>SQL 2000 or MSDE 2000 will let you install databases with
collations other
>than the one that SQL Server was installed with. That is
one of its major
>advantages over SQL 7.
>
>Once you have the database attached in SQL 2000, you can
copy with DTS to a
>new database in SQL 7.
>
>--
>**********************************************************
*********
>Andy S.
>MCSE NT/2000, MCDBA SQL 7/2000
>andymcdba1@NOMORESPAM.yahoo.com
>
>Please remove NOMORESPAM before replying.
>
>Always keep your antivirus and Microsoft software
>up to date with the latest definitions and product
updates.
>Be suspicious of every email attachment, I will never send
>or post anything other than the text of a http:// link nor
>post the link directly to a file for downloading.
>
>
>**********************************************************
*********
>"Eureca" <anonymous@discussions.microsoft.com> wrote in
message
>news:1192901c3bfbe$1b5bd340$a601280a@phx.gbl...
>> Hi, I have to import a database in SQL 7.0 Service Pack
4
>> from which I have the *.mdf and *.ldf files in a new
>> server. The problem I get when I do "sp_attach_db" is:
>>
>> "Server: mesagge 1816, level 16, state 1, line 1
>> Cannot attach db due to the difference in Character Set,
>> Sort Order or Unicode intercalation.
>>
>> Warning: Unicode language locale 1033 from the db is
>> different than the server Unicode language locale, 1034.
>> Warning: Unicode language locale 1033 from the db is
>> different from the Server, Unicode language locale de
1034.
>>
>> If I make a new instal of the SQL 7 Server and I choose
>> the Default or Typical setup I get the Server installed
>> with Locale 1033 but I find that it install the sort
order
>> as ISO character set and this also differs from the db I
>> have so I need "850 Multilingual Character Set" and NOT
>> ISO-Character Set.
>>
>> Any explanation for this/way to solve it? Maybe
installing
>> SQl 2000 and trying to upgrade db?
>>
>> Thanks in advance
>>
>
>
>.