Solution : https://service.sap.com/sap/support/notes/600027 (SAP Service marketplace login required)
Summary :
This SAP Note provides guidance on configuring the correct collation setting for MS SQL Server 2000 databases used with SAP systems. It specifies the use of the “SQL_Latin1_General_CP850_BIN2” collation, which corrects sorting issues with Unicode data not addressed by the default collation. For new installations, the database should initially be set to use "Binary order for use with the 850 Multilingual Character Set." Subsequently, users should install SQL Server 2000 SP4 or later, then apply the new collation using InstColl.exe provided by SAP. This executable modifies the collation setting post-installation. Existing non-Unicode SAP systems do not require conversion unless a new Unicode system is to be added.
Key words :
homogeneous system copy sql server databases, -apply sql server service pack 4, 47 spid1 default collation successfully changed, install sql service pack 4, manually shutdown sql server, sql server books online, sql server service pack 4, start sql server manually, original command window informing, single sql server instance
Related Notes :
| 1476928 | System copy of SAP systems on Windows 2008 (R2): SQL Server |
| 1074030 | R3trans: "Duplicate key" composite SAP note (as of Rel 6.10) |
| 1019320 | sap_update_MSSDBSTATT Cannot resolve collation conflict |
| 919835 | Collation of local IPC database in unicode. |
| 905634 | Release planning for Microsoft SQL Server 2005 |
| 635527 | SAP SCM 4.0 Server inatallation/upgrade Asia |
| 608651 | SQL Server 2000 Most Recent Hotfix |
| 505906 | SQL Server: Incorrect collation |
| 193816 | Restore with SQL Server |
| 151603 | Copying an SQL Server database |
| 88656 | R3trans: Duplicate key composite SAP note (Release 4.0-4.6) |
| 62988 | Service Packs for Microsoft SQL Server |