Thursday, 24 May 2012

How to change the default collation of SQL 2008 R2 database

I've managed to change mine with this following statement. It only took about 4 mins to fix, once I'd got the right installer files mounted on my V drive, and shut down my virus scanner.

Ran this from a VS 2008 .NET command prompt, after shutting down all my sql server services too…

V:\>setup /Q /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SAPWD=NotTellingYou! /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /SqlCollation=Latin1_General_CI_AI

No comments:

Post a Comment