Set or Change the Database Collation

SQL Server 2008 R2 SQL Server 2008 SQL Server 2005 This topic describes how set and change the database collation in SQL Server 2014 by using SQL Server Management Studio or Transact-SQL. If no collation is specified, the server collation is used. ...

msdn.microsoft.com