---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

In general se face rebuild la master http://support.microsoft.com/kb/257716

Q. How do I rebuild the master database?

A: To rebuild the master database of a SQL Server 2000 instance, use the Rebuild Master Utility, Rebuildm.exe. You must rebuild the master database to fix corrupted master databases or to change collation settings for the instance. Detailed steps and information are available in the "How to rebuild the master database" topic in SQL Server Books Online. Also, be aware of the issue that is mentioned in the following article in the Microsoft Knowledge Base:

273572 (http://support.microsoft.com/kb/273572/) BUG: Rebuildm.exe utility stops responding when source directory is on a CD

Sa inteleg ca pe 2000 se putea face asta?
Sau nu am inteles eu despre ce e vorba?
Sau nu am inteles cum e in 2005?

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:

• Setting and Changing the Server Collation
  
• Setting and Changing the Database Collation
  
• Setting and Changing the Column Collation
  
• Setting Expression Collation
  
• Identifier Collation
  

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

  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.
  

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

xmldeveloper:

Insa eu ti-as recomanda sa schimbi collation la nivel de baza de date cu ALTER DATABASE.

Eu am confundat putin "collation" cu "collation setting" cred despre care in ghidul de studiu pentru 70-431 de la Sybex se zice:

"once you have installed SQL Server, you cannot change the collation setting. To change it, you must reinstall SQL Server and rebuild all your databases. So, choose wisely; it is usually best to use the default sort setting of case insensitivity and build sensitivity into your applications if you need it."

Si cu collation de baza de date m-am tot jucat, si in general a mers bine si fara probleme. 

Razvan un ALTER DATABASE e mai pasnic decat un rebuild de master. Parerea mea personala!

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro