How to change Server Collation?

Aside from reinstalling, is there a way to change the
server collation settings?No. You can change the collation of individual columns with ALTER TABLE
ALTER COLUMN, but this has lots of caveats and can be difficult depending
on your schema. If you must change the instance-level default collation,
the only options are (a) a reinstall, or (b) use the Rebuild Master utility
(rebuildm.exe). RebuildM will replace your system databases, so extract or
backup anything you need from them before running it. Also, RebuildM will
change the instance-level defaults but it doesn't change the collation of
any existing user databases.
Bart
--
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
Content-Class: urn:content-classes:message
From: "Noldz" <rdevera@.wizardsgroup.com>
Sender: "Noldz" <rdevera@.wizardsgroup.com>
Subject: How to change Server Collation?
Date: Mon, 6 Oct 2003 20:14:17 -0700
Lines: 2
Message-ID: <09c601c38c81$178ecc10$a301280a@.phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcOMgReOEkR3oghcTTStBjXKZ+hd2w==Newsgroups: microsoft.public.sqlserver.server
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:309919
NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
X-Tomcat-NG: microsoft.public.sqlserver.server
Aside from reinstalling, is there a way to change the
server collation settings?|||Noldz,
You can also set a database's collation when creating it. So a given SQL
Server can have many databases, each with different collations.
Ron
--
Ron Talmage
SQL Server MVP
"Noldz" <rdevera@.wizardsgroup.com> wrote in message
news:09c601c38c81$178ecc10$a301280a@.phx.gbl...
> Aside from reinstalling, is there a way to change the
> server collation settings?|||Hi Ron,
Thanks for replying.
Master DB Collation was set to case-sensitive. So when you
use the fully qualified name in distributed queries
eg. "db.dbo.tabname" instead of "DB.dbo.tabname" it
returns invalid object name "db.dbo.tabname".
I already reinstall my sql server and my web apps works
perfectly.
regards,
Noldz
>--Original Message--
>Noldz,
>You can also set a database's collation when creating it.
So a given SQL
>Server can have many databases, each with different
collations.
>Ron
>--
>Ron Talmage
>SQL Server MVP
>"Noldz" <rdevera@.wizardsgroup.com> wrote in message
>news:09c601c38c81$178ecc10$a301280a@.phx.gbl...
>> Aside from reinstalling, is there a way to change the
>> server collation settings?
>
>.
>