Re: Changing server collation

From: Jfhayes (Jfhayes_at_discussions.microsoft.com)
Date: 09/15/04 

Date: Tue, 14 Sep 2004 19:35:01 -0700

That is exactly what I am saying. The serverproperty shows the collation as
Sql_ Latin1_General. I tried an uninstall, since it is a brand new server.
I could start from scratch, but now my curiosity is up on how to change it.

Thanks for any assistance you can give.

"Tibor Karaszi" wrote:

> Are you saying that you did REBUILDM.EXE and after that you don't have the collation you specified
> in REBUILDM.EXE? What does the SERVERPROPERTY() function say?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Jfhayes" <Jfhayes@discussions.microsoft.com> wrote in message
> news:2381BB08-B280-41FE-A584-325616304C0C@microsoft.com...
> >I just did a new MSSql 2000 Server install, unfortunately with the wrong
> > Default Collation. Since I have no user databases attached, I just ran the
> > rebuildm. When I look at rebuildM now, it shows Dictionary Order, Case
> > Insensitive, for use with Code 1251. However, the Sp_HelpSort still shows
> > Latin1-General, and the Server Collation still shows Sql_Latin1_general.
> > ...How can I change this to default Code Page 1252?
> >
> > Many Thanks
>
>
>

Relevant Pages

  • Re: Software Inventory - Microsoft License True Up - SQL Version and P
    ... SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY, ... the Microsoft True Up, in particular reference to MS SQL. ... Has anybody had success in determining inventory information for MS SQL ...
    (microsoft.public.sms.admin)
  • Re: SQL Serverlicense compliance
    ... Have you tried doing a "select serverproperty " in SQL? ... or extend WMI and get this over to Hardware Inventory. ... "Henrik " wrote in message ...
    (microsoft.public.sms.inventory)
  • Re: SQL License
    ... Check out SERVERPROPERTY() in BOL. ... Andrew J. Kelly SQL MVP ... > Is there a Query to find the licesnse scheme that SQl is using? ... procesor or per seat and does it give a quantity? ...
    (microsoft.public.sqlserver.programming)
  • 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)