28. februar 2007 - 21:55Der er
3 kommentarer og 1 løsning
SQL Server 2005 med SQL_Latin1_General_CP850_BIN character set
Jeg vil gerne have min SQL Server 2005 til at køre med SQL_Latin1_General_CP850_BIN character set. Er der nogen som ved, hvordan man får SQL Server 2005 ændret til at køre med det?
Med kunstig intelligens skaber HP’s nye OmniBook X 14 en unik og skræddersyet brugeroplevelse målrettet dem, der ønsker høj ydeevne og intelligente funktioner
Collation settings, which include character set, sort order, and other locale-specific settings, are fundamental to the structure and function of all SQL Server databases. You should develop a standard within your organization for these options, and apply them at the time of installation. Many server-to-server activities can fail if collation settings are not consistent across servers.
When installing SQL Server 2005, use the correct collation settings. You can change collation settings after running Setup, but you must rebuild the system and user databases and reload user data if you do.
To change collation settings for an existing instance of SQL Server 2005, you must use unattended Setup to rebuild the system databases. This functionality is exposed using a special switch called REBUILDDATABASE=1. When system databases are rebuilt, all database objects and data in master, model and msdb system databases are removed. Rebuilding the master database installs all system databases to their initial location. If you have moved one or more system databases to a different location, you must move the databases again. For more information about moving system databases, see Moving System Databases.
Your syntax must specify either the /qb or /qn option. The /qb option displays basic Setup user interface and error message dialog boxes. If the /qn option is specified, all Setup dialog boxes, including error messages, are written to Setup log files. Important: In order to rebuild system databases, a new System Administrator (sa) password is REQUIRED. Do not use a blank password. Use a strong password.
To rebuild system databases and specify a new system collationTo rebuild system databases and specify a new system collation
1.
Insert the SQL Server 2005 installation media into the disk drive. 2.
Run the following command from the command prompt:
start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword> SQLCOLLATION=<NewSystemCollation>
For INSTANCENAME, use MSSQLSERVER for a default instance. For a named instance, specify the instance name. Important: The resource database (mssqlsystemresource) is restored from SQL Server 2005 distribution media. When you rebuild the resource database from distribution media, all service packs and hotfix updates are lost, and therefore must be reapplied. Before you proceed, see the [REBUILDDATABASE] section for more information.
The /qn switch suppresses all Setup dialog boxes and error messages. If the /qn switch is specified, all Setup messages, including error messages, are written to Setup log files. For more information about log files, see How to: View SQL Server 2005 Setup Log Files. The /qb switch allows display of basic Setup dialog boxes. Error messages are also displayed.
Rebuilding the master database installs all system databases to their initial location. If you have moved one or more system databases to a different location, you must move the databases again. For more information about moving system databases, see Moving System Databases.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.