数据库的排序规则（Collation of databases）.docVIP

数据库的排序规则（Collation of databases） Could you tell me how to change the sort rules 1.sp_helpsort SELECT SERVERPROPERTY (Collation) Check your ranking rules. But this should be your character set. 2. change the server collation The default collation change SQL Server 2005 instance of the operation may be more complex, including the following steps: To ensure that all the information needed to re create the script or all objects in the database and the user database. The use of tools (such as bulk copy) to export all data. Delete all user database. The new generation of specified new collation in the SQLCOLLATION attribute of the setup command in the master database. For example: Copy the code Start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI For more information about rebuilding the master database, see how to rebuild the SQL Server 2005 Master database. All objects are created and all databases in these databases. Import all data. Be careful： You can specify the default collation for each new database is created, the default collation and does not change the SQL Server 2005 instance. 3. set and change the collation of the database Create a new database, you can use one of the contents of the specified collation: The COLLATE CREATE clause of the DATABASE statement. SQL Server Management Studio. The SQL management object (SMO) in the Database.Collation property. If you do not specify a collation, server collation. The collation clause of the COLLATE can use the ALTER DATABASE statement to change any of the new object is created in the user database. Column sorting rules using this statement can not change any existing user defined table. Use the COLLATE clause ALTER TABLE can change the collation of these columns. Change the collation of the database, need to change the following: The default collation of the database, a new default ranking rules will be applied to the database p