Monday, March 2, 2009

How to change the SQL Server 2005 - Engin Collation

it's easy to change the database collation by using alter database but must of the time we want to change the sql-engin collation.
to do this:
  1. detache all database
  2. copy the mdf & ldf files
  3. go SQL-Server CD--> setup folder
  4. run : setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=xxxxx SQLCOLLATION=
  5. attach the databases again

No comments: