Database Engine, T-SQL

How to change the collation of a database in SQL Server?

go site Have you ever wondered how to change the collation for a database in SQL Server?

rencontres seniors 62 Well the other day I received a database from a third party supplier and the first step was to change the Collation of the database. My questioning about why they would supply the database in the incorrect collation setting was met with a wall of silence. Therefore I had to put in my documentation how to change the Collation of the database.

go to site I did it the quick way by right click on database > Select properties > options > Select appropriate collation from dropdown menu next to Collation.

Database properties
Database properties That was a good enough solution at the time but for my documentation I would always add the T-SQL so that anyone could follow the guide without making mistakes.

grafici opzioni binarie online Below is an example of how to change the Collation via T-SQL

conocer gente soltera en barcelona ALTER DATABASE AdventureWorks2012 COLLATE SQL_Latin1_General_CP850_BIN

watch Please let me know whether you found this guide useful and leave a message in the comments.

Leave a Reply