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
- For more information about rebuilding the master database, see How to: Rebuild the Master Database for SQL Server 2005.
- Create all the databases and all the objects in them.
- Import all your data.
Link de documento
http://msdn.microsoft.com/en-us/library/ms179254(SQL.90).aspx
Link con lista de collation options
http://msdn.microsoft.com/en-us/library/ms144250(SQL.90).aspx
***
No hay comentarios:
Publicar un comentario