Skip to Content
0
Nov 10, 2008 at 09:31 AM

Changing SQL 2005 sp 2 SERVER collation?

16 Views

Hi everyone

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

Kind regards

Søren