Re: DRW issues - sql collation

From: Evan [MSFT] (esc_at_online.microsoft.com)
Date: 08/20/04 

Date: Fri, 20 Aug 2004 08:50:08 -0700

Ah, good. Which item in "sql collation" did you choose to get that? 

-- 
This posting is provided "AS IS" with no warranties, and confers no rights.
"Torsten" <torsten.meringer@NOSPAM.web.de> wrote in message 
news:DA92FFCA-AE69-40F8-90CB-F106B3853C31@microsoft.com...
> Meanwhile I moved a few steps forward. If you use 'SQL Collations' instead 
> of
> 'Collation designator' settings during setup (or with rebuildm), you're 
> able
> to change the collation to "SQL-Latin1_General_CP437_CI_AS".
> Does anybody know a way to change even the codepage from CP437 to CP1 ? 
> Then
> this would be the solution and I'd be happy again ! :-)
>
> Thanks,
> Torsten
>
> "Evan [MSFT]" wrote:
>
>> They both contain Latin1 but they're still different. You must determine
>> which sql installation settings will cause tempdb to match the sms db
>> collation, then use rebuildm or install sql with that collation on 
>> another
>> box and point sms to that db. If you don't remember what installation
>> settings you used to get "SQL_Latin1_General_CP1_CI_AS", then try 
>> installing
>> sql with various settings on another box until you find one that gives 
>> that
>> collation. Then you'll know what settings to use to match the sms db.
>>
>> -- 
>> This posting is provided "AS IS" with no warranties, and confers no 
>> rights.
>> "Torsten" <torsten.meringer@NOSPAM.web.de> wrote in message
>> news:76C32BAD-58BE-4797-B973-EE396EF41474@microsoft.com...
>> > Hi,
>> >
>> > (I'm posting this message again as it appears only in my webbrowser but
>> > not
>> > in my newsreader)
>> >
>> > I've a little problem with the DRW.
>> > I get an error while checking "Collation of temp database and SMS 
>> > database
>> > should be the same". How can I resolve this ? Reinstalling SQL or 
>> > running
>> > 'rebuildm.exe' doens't help me out, because both collations are already
>> > set
>> > to "Latin1".
>> >
>> > The collation of my tempdb is "Latin1_General_CI_AS" and smsdb =
>> > "SQL_Latin1_General_CP1_CI_AS".
>> >
>> > Any ideas here ?
>> >
>> > Thanks a lot,
>> > Torsten
>> >
>>
>>
>>

Relevant Pages

  • Re: DRW issues - sql collation
    ... which sql installation settings will cause tempdb to match the sms db ... collation, then use rebuildm or install sql with that collation on another ... box and point sms to that db. ...
    (microsoft.public.sms.admin)
  • RE: Install SQL Server 2000 with different COLLATION
    ... When you upgrade an existing SQL 7.0 instance, ... always inherits the 7.0 instance's collation. ... If you want to install SQL ... Microsoft SQL Server Support ...
    (microsoft.public.sqlserver.server)
  • Re: To unicode or not?
    ... Then again, since SQL Server stores Unicode data in the UCS-2 encoding, ... use them with varchar, you simply work with a subset of the characers, ... an SQL collation is just a Windows collation ...
    (comp.databases.ms-sqlserver)
  • Re: changing the SORT Collations
    ... Collation in SQL 2000 is now a per database setting. ... To change the sort order for the ... server, you have to detach all databases, uninstall and reinstall SQL in the ...
    (microsoft.public.sqlserver.server)
  • Re: Japanese Text
    ... the commands are for SQL Server 2000 as SQL 2000 allows for different ... database-level collations as well as different column-level collations. ... inserting or updating the Japanese text using the N prefix, ... > box as shown in the article to alter collation. ...
    (microsoft.public.sqlserver.fulltext)