CODEWITHSUNDEEP
sql-serversql-server-2008sql-server-2008-r2
Jack Reilly
Jack Reilly

Reputation: 168

SQL Server 2008 R2 has wrong default collation

When I installed SQL Server initially, my computer region was set to ENGLISH (UNITED STATES). I think this made the default collation SQL_Latin1_General_CP1_CI_AS. The production server and my colleague's SQL Server setups have Latin1_General_CI_AS.

I changed my region to match theirs as ENGLISH (Australia) and I uninstalled SQL Server 2008 and deleted the databases. I then reinstalled, but it's still SQL_Latin1_General_CP1_CI_AS for collation.

I've now reinstalled several times, and I can't have my default collation set to Latin1_General_CI_AS.

Does anyone know how to change this? Where when installing does it let you choose your collation?

Upvotes: 2

Views: 144

Answers (1)

Nolan Shang
Nolan Shang

Reputation: 2328

setup.exe /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MSSQLSERVER 
          /SQLSYSADMINACCOUNTS="NT AUTHORITY\SYSTEM" 
          /SQLCOLLATION=Latin1_General_CI_AS

Upvotes: 3

Related Questions