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 to connect to SQL Server 2000 using Enterprise Manager?

To connect to your Microsoft SQL Server database using Enterprise Manager to manage your...

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...

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...

Do you support MSDE 2000?

No. We do not support MSDE 2000. The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a...

Do you support MSSQL Express

No. We do not support this type of database as this database is only meant for development...