Pentru SQL Server 2005: Setting and Changing Collations
SQL Server 2005 collations can be specified at any level. When you install an instance of SQL Server 2005, you specify the default collation for that instance. Each time that you create a database, you can specify the default collation used for the database. If you do not specify a collation, the default collation for the database is the default collation for the instance. Whenever you define a character column, variable, or parameter, you can specify the collation of the object. If you do not specify a collation, the object is created by using the default collation of the database.
The following topics explain how to work with collations at the server, database, column, expression, and identifier levels:
La nivel de instanta: Setting and Changing the Server Collation
Changing the Server Collation
Changing the default collation for an instance of SQL Server 2005 can be a complex operation and involves the following steps:
- Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them.
- Export all your data using a tool such as bulk copy.
- Drop all the user databases.
- Rebuild the master database specifying the new collation in the SQLCOLLATION property of the setup command. For example:
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI
- Create all the databases and all the objects in them.
- Import all your data.
.gif) Note: |
|---|
| Instead of changing the default collation of an instance of SQL Server 2005, you can specify a default collation for each new database you create. |
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro