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 Transfer SQL database from My Database Server to your Database Server

From the Start Menu, select Programs -> Microsoft SQL Server -> Import and...

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 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 logins for my MS SQL database?

For old In House Control Panel : No. We only provide a single database user login. For...

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?

...