Re: DRW issues - sql collation
From: Torsten (torsten.meringer_at_NOSPAM.web.de)
Date: 08/20/04
- Next message: Bobs: "Re: sms 2 to sms 2003"
- Previous message: walt: "Distribution point error"
- In reply to: Evan [MSFT]: "Re: DRW issues - sql collation"
- Next in thread: Evan [MSFT]: "Re: DRW issues - sql collation"
- Reply: Evan [MSFT]: "Re: DRW issues - sql collation"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Aug 2004 04:55:03 -0700
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
> >
>
>
>
- Next message: Bobs: "Re: sms 2 to sms 2003"
- Previous message: walt: "Distribution point error"
- In reply to: Evan [MSFT]: "Re: DRW issues - sql collation"
- Next in thread: Evan [MSFT]: "Re: DRW issues - sql collation"
- Reply: Evan [MSFT]: "Re: DRW issues - sql collation"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
