I was wondering if there where anyone that had any luck changing the server collation on a sql 2005 with sp2. I tried the sap notes (987436) and followed the webex but keep getting an error. Sap support told me to uninstall the sp 2 which Iu2019m not too keen on. I tried on a test system and if I uninstall the sp2 (remove the sql server because you canu2019t uninstall sp2) it works fine.
From the notes:
u2026.setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD="you sa password" SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS