Thursday, May 20, 2010

Changing Database COLLATION

1. Litespeed uninstall.

2. set Password and collation execute the following.

D:\Installs\SQL2005ENTSELX64dvd\Servers>start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=******* SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

3. APPLY CU3

No comments: