Re: DRW issues - sql collation

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

Date: Thu, 19 Aug 2004 10:30:27 -0700

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: Yet another SQL Express SP2 on Vista Problem...
    ... default collation is dependent on your regional settings ... Microsoft SQL Server databases. ...
    (microsoft.public.sqlserver.setup)
  • Re: DRW issues - sql collation
    ... 'Collation designator' settings during setup (or with rebuildm), ... > which sql installation settings will cause tempdb to match the sms db ...
    (microsoft.public.sms.admin)
  • Re: DRW issues - sql collation
    ... Which item in "sql collation" did you choose to get that? ... This posting is provided "AS IS" with no warranties, ... >> box and point sms to that db. ...
    (microsoft.public.sms.admin)
  • Re: Setting SQL Server memory option for SMS 2003
    ... if you want to set some settings to see how they will ... affect performance in your environment, ... Limit SQL memory to 1GB. ... SMS and SQL are on the same system and ...
    (microsoft.public.sms.setup)
  • Re: DRW issues - sql collation
    ... SQL7 and this box was upgraded from SQL 7 to 2000 a long time ago. ... Reinstalling or changing the collation to SQL_Latin1... ... install SQL 2000 on win2k3 so the collation of the smsdb would still be the ... When applying a sms servicepack the drw would come up with the same ...
    (microsoft.public.sms.admin)