case sensitive instance?

How do I tell if an instance is case sensitive? I know it's something you ca
n set when installing SQL Server but can it be changed after installation?Run sp_helpsort in query analyzer
"J Jetson" wrote:

> How do I tell if an instance is case sensitive? I know it's something you can set
when installing SQL Server but can it be changed after installation?|||RICHARD SAWTELL
"csb007" <csb007@.discussions.microsoft.com> wrote in message
news:3CEB4190-5DD9-4733-B8BE-A669469D3EE6@.microsoft.com...[vbcol=seagreen]
> Run sp_helpsort in query analyzer
> "J Jetson" wrote:
>
you can set when installing SQL Server but can it be changed after
installation?
You can change the collation sequence in several different locations.
When you install SQL Server, you pick a default for all databases.
When you issue a CREATE DATABASE, you can specify a different default
sequence, just for that database. When you issue a CREATE TABLE, you can
specify a different sequence for each character datatype in the table.
To change the default server collation sequence essentially requires a
rebuild of the master database.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Have a look in BOL at the topic "collations" - things are now (SQL 2000) a
fair bit more complicated than having a case-sensitive choice only on
installation.
On installation you select the server collation which can be reset by
rebuilding master of reinstallation. This is the one returned by sp_helpsort
or using SERVERPROPERTY('Collation').
There are 2 other levels of collation: database and column, both of which
can be altered directly.
HTH,
Paul Ibison