RE: Install SQL Server 2000 with different COLLATION
From: Bart Duncan [MSFT] (bartd_at_online.microsoft.com)
Date: 01/05/05
- Next message: ניר פתאל: "problem after restore the database without the master"
- Previous message: bing: "Re: help on SQL UPDATE needed"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 05 Jan 2005 15:57:40 GMT
Matt,
When you upgrade an existing SQL 7.0 instance, the new SQL 2K instance
always inherits the 7.0 instance's collation. If you want to install SQL
2000 with a different collation, you have to install a new instance (or
uninstall the 7.0 default instance and install a new SQL 2K default
instance). To install with collation SQL_Latin1_General_CP1_CI_AS, choose
an Advanced install, then select "SQL Collations" and "Dictionary order,
Case insensitive, Accent sensitive for use with Code Page 1252". You can
attach your existing 7.0 databases to the new SQL 2K instance, but the
attached database will retain their original collation from the 7.0
instance.
Bart
------------
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| X-Tomcat-ID: 160765285
| References: <F833038D-725A-4C2F-B8BB-BBFAC8823D30@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-sguo@online.microsoft.com (Sophie Guo [MSFT])
| Organization: Microsoft
| Date: Thu, 30 Dec 2004 08:38:35 GMT
| Subject: Install SQL Server 2000 with different COLLATION
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <TfDaqrk7EHA.768@cpmsftngxa10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 54
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:372631
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| Dear Matt,
|
| Please refer to the following article to upgrade SQL Server 7.0 to SQL
| Server 2000:
|
| How to upgrade a SQL Server 7.0 installation to SQL Server 2000 (Setup)
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht
| _install_5vsj.asp
|
| An upgrade of SQL Server 7.0 to SQL Server 2000 keeps the previous SQL
| collation settings; no collation choice is required. You can refer to
the
| following article:
|
| Using SQL Collations
|
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_
| collation_8f8w.asp
|
| After installation, you can change Collation Settings. Microsoft SQL
| Server 2000 collations can be specified at several levels, please refer
to
| the following article:
|
| Specifying Collations
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
| ar_da_3zw3.asp
|
| Collation settings, which include character set, sort order, and other
| locale-specific settings, are fundamental to the structure of all
| Microsoft SQL Server 2000 databases. To change one or more of these
| settings, you must rebuild the master and user databases.
|
| Please refer to the following articles:
|
| Changing Collation Settings After Installing
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_
| collation_19ym.asp
|
| How to rebuild the master database (Rebuild Master utility)
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht
| _install_8w8p.asp
|
| However, if you run rebuildm utility to change collation of an instance,
| much information in master may lose. Therefore, please make sure you have
| back up the database files of each database if you want to try this.
|
| I hope this helpful.
|
|
| Sophie Guo
| Microsoft Online Partner Support
|
| Get Secure! - www.microsoft.com/security
|
| =====================================================
| 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.
|
|
From: =?Utf-8?B?TWF0dCBDYWxob29u?= <matt@community.nospam>
Subject: Install SQL Server 2000 with different COLLATION
Date: Wed, 29 Dec 2004 15:13:04 -0800
Newsgroups: microsoft.public.sqlserver.server
Hi there,
I have a windows 2000 box with SQL 7.0 installed. When I install SQL 2000,
it sets the COLLATION to the default Collation of SQL 7.0, however I need
this set to the collation of SQL_Latin1_General_CP1_CI_AS
How can I set the collation when installing?
thanks - matt
- Next message: ניר פתאל: "problem after restore the database without the master"
- Previous message: bing: "Re: help on SQL UPDATE needed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
