Change collation type in SQL Server

To change a collation of database use this statement.

USE Tempdb
GO
ALTER DATABASE Pubs COLLATE French_CI_AS
GO

Was this answer helpful?

 Print this Article

Also Read

How do I get a copy of MS SQL Enterprise Manager and Query Analyser?

Microsoft does not distribute MS SQL client tools individually, they are bundled with MS SQL...

I want to use a domain I already own, but do I have to transfer my domain name to you?

If you already own a domain name and you wish to use that domain name with a hosting account on...

Cannot expand Databases in Management Studio

Error: Management Studio Express 2008 to access my shared hosted SQL 2005 / 2008 Standard. I...

Can I have more than 1 database with my MS-SQL account?

Yes, please create a support ticket for more information. The quota of the MSSQL database came...

I am able to view and access a SQL database other than my own while connected with Enterprise Manager, Query Analyzer, or the SQL Web admin. What is wrong?

...