Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Steve Kass
Christophe,
Je ne peux pas trouver les renseignements en français, mais les voilà en anglais, avec liens à microsoft.com.
Changing collations:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_8uer.asp To change the default collation for an instance of Microsoft® SQL Server™ 2000 you must: * Make sure you have all of the information or scripts needed to re-create your user databases and all of the objects in them. * Export all of your data using a tool such as bulk copy. * Drop all of the user databases. * Rebuild the master database specifying the new collation. * Create all of the databases and all of the objects in them. * Import all of your data. Note Instead of changing the default collation of an instance of SQL Server 2000, you can specify a default collation for each new database you create.
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 To rebuild the master database 1. Shutdown Microsoft® SQL Server™ 2000, and then run Rebuildm.exe. This is located in the Program FilesMicrosoft SQL Server80ToolsBinn directory. 2. In the Rebuild Master dialog box, click Browse. 3. In the Browse for Folder dialog box, select the Data folder on the SQL Server 2000 compact disc or in the shared network directory from which SQL Server 2000 was installed, and then click OK. 4. Click Settings. In the Collation Settings dialog box, verify or change settings used for the master database and all other databases. Initially, the default collation settings are shown, but these may not match the collation selected during setup. You can select the same settings used during setup or select new collation settings. When done, click OK. 5. In the Rebuild Master dialog box, click Rebuild to start the process. The Rebuild Master utility reinstalls the master database. Note To continue, you may need to stop a server that is running.
Procéder à vos risques et périls.
Steve Kass Drew University
Christophe wrote:
Bon pour changer la collation au niveau du serveur pour un 2005 y'a un script qui reconstruit master
mais pour 2000 comment peut t'on le changer ? si il faut remettre une nouvelle master quelle est la procedure ?
Merci
Christophe,
Je ne peux pas trouver les renseignements en français, mais
les voilà en anglais, avec liens à microsoft.com.
Changing collations:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_8uer.asp
To change the default collation for an instance of Microsoft® SQL
Server™ 2000 you must:
* Make sure you have all of the information or scripts needed to
re-create your user databases and all of the objects in them.
* Export all of your data using a tool such as bulk copy.
* Drop all of the user databases.
* Rebuild the master database specifying the new collation.
* Create all of the databases and all of the objects in them.
* Import all of your data.
Note Instead of changing the default collation of an instance of
SQL Server 2000, you can specify a default collation for each new
database you create.
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
To rebuild the master database
1. Shutdown Microsoft® SQL Server™ 2000, and then run Rebuildm.exe.
This is located in the Program FilesMicrosoft SQL Server80ToolsBinn
directory.
2. In the Rebuild Master dialog box, click Browse.
3. In the Browse for Folder dialog box, select the Data folder on
the SQL Server 2000 compact disc or in the shared network directory from
which SQL Server 2000 was installed, and then click OK.
4. Click Settings. In the Collation Settings dialog box, verify or
change settings used for the master database and all other databases.
Initially, the default collation settings are shown, but these may
not match the collation selected during setup. You can select the same
settings used during setup or select new collation settings. When done,
click OK.
5. In the Rebuild Master dialog box, click Rebuild to start the process.
The Rebuild Master utility reinstalls the master database.
Note To continue, you may need to stop a server that is running.
Procéder à vos risques et périls.
Steve Kass
Drew University
Christophe wrote:
Bon pour changer la collation au niveau du serveur pour un 2005
y'a un script qui reconstruit master
mais pour 2000 comment peut t'on le changer ?
si il faut remettre une nouvelle master quelle est la procedure ?
Je ne peux pas trouver les renseignements en français, mais les voilà en anglais, avec liens à microsoft.com.
Changing collations:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_8uer.asp To change the default collation for an instance of Microsoft® SQL Server™ 2000 you must: * Make sure you have all of the information or scripts needed to re-create your user databases and all of the objects in them. * Export all of your data using a tool such as bulk copy. * Drop all of the user databases. * Rebuild the master database specifying the new collation. * Create all of the databases and all of the objects in them. * Import all of your data. Note Instead of changing the default collation of an instance of SQL Server 2000, you can specify a default collation for each new database you create.
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 To rebuild the master database 1. Shutdown Microsoft® SQL Server™ 2000, and then run Rebuildm.exe. This is located in the Program FilesMicrosoft SQL Server80ToolsBinn directory. 2. In the Rebuild Master dialog box, click Browse. 3. In the Browse for Folder dialog box, select the Data folder on the SQL Server 2000 compact disc or in the shared network directory from which SQL Server 2000 was installed, and then click OK. 4. Click Settings. In the Collation Settings dialog box, verify or change settings used for the master database and all other databases. Initially, the default collation settings are shown, but these may not match the collation selected during setup. You can select the same settings used during setup or select new collation settings. When done, click OK. 5. In the Rebuild Master dialog box, click Rebuild to start the process. The Rebuild Master utility reinstalls the master database. Note To continue, you may need to stop a server that is running.
Procéder à vos risques et périls.
Steve Kass Drew University
Christophe wrote:
Bon pour changer la collation au niveau du serveur pour un 2005 y'a un script qui reconstruit master
mais pour 2000 comment peut t'on le changer ? si il faut remettre une nouvelle master quelle est la procedure ?
