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

How to replace the watch battery in Logitech K750 solar power keyboard

Buy this battery http://www.watchbattery.co.uk/shop/products/BB-ML2032.shtml Open the battery cover on the back of the keyboard, you’ll need...