Re: Yet another SQL Express SP2 on Vista Problem...
- From: petery@xxxxxxxxxxxxxxxxxxxx ("Peter YangMSFT]")
- Date: Tue, 12 Jun 2007 03:18:06 GMT
Hello Tony,
Per your question, default collation is dependent on your regional settings
and if you select to use SQL collation. Non-case sensitive collation is
usually the default collation. For exmaple, if you select Windows collation
and region setting is English (United States), it defaults to a
case-insenesitve collation. "CI" in the collation means Case Insenstive.
English (United States) SQL_Latin1_General_CP1_CI_AS
Collation settings, which include character set, sort order, and other
locale-specific settings, are fundamental to the structure and function of
Microsoft SQL Server databases. Within your organization, you should
develop a standard for collation settings, and apply these settings at the
time that you install SQL Server. Many server-to-server activities can fail
or yield inconsistent results if collation settings are not consistent
across servers. Select a Microsoft Windows locale to match the collation
settings in other instances of SQL Server 2005; or select SQL Collations to
match settings with the sort orders in earlier versions of SQL Server.
You may want to check the following topic in Books Online for more related
information:
Collation Settings in Setup
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/11ce1a3d-8314-41a3-be5f-
03db90bea61b.htm
You could not change server collation after you install the SQL Server
instance unless you run setup to rebuild system databases. However, you
could use different collation for a database, table, column etc. You may
want to see "create database", "create table" topics in Books Online for
details.
To rebuild system databases and specify a new system collation
Insert the SQL Server 2005 installation media into the disk drive.
Run the following command from the command prompt:
start /wait <DVD Drive>\setup.exe /qn INSTANCENAME=MSSQLSERVER
REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
SQLCOLLATION=<NewSystemCollation>
Please see the following article in Books Online for more information:
How to: Install SQL Server 2005 from the Command Prompt
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-
78a57852364d.htm
More related information:
SQL Server 2000 Collation Changer
http://www.codeproject.com/vb/net/ChangeCollation.asp
If anything is unclear or you have further comments, please feel free to
let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
.
- Follow-Ups:
- References:
- Prev by Date: Re: sql2k5 performance
- Next by Date: Re: ?? SQL Server 2005 Express SP2 Install Fails on Native Client ??
- Previous by thread: Re: Yet another SQL Express SP2 on Vista Problem...
- Next by thread: Re: Yet another SQL Express SP2 on Vista Problem...
- Index(es):
Relevant Pages
|
