Web Analytics Made Easy - Statcounter

Technology with Vivek Johari

SQL Basic Concepts SQL Server

How to change the database collation

Byvivekjohari

Jan 2, 2012 #SQL Basic Concepts
To change the collation of an database following commands can be used:

ALTER DATABASE [database name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE  [database name]  COLLATE Newcollation
ALTER DATABASE  [database name]  SET MULTI_USER
For example , suppose if the name of your database is learningdb and you want to change the collation to the collation SQL_Latin1_General_CP1257_CI_AS, then following commands can be used:-
ALTER DATABASE 
learningdb  SET SINGLE_USER WITH ROLLBACKIMMEDIATE
ALTER DATABASE 
learningdb  COLLATE SQL_Latin1_General_CP1257_CI_AS
ALTER DATABASE 
learningdb  SET MULTI_USER

By vivekjohari

I am currently working as a Senior Database Professional and have around 18 years of experience in database. Degree:- Master Degree in Computer(MCA) Certification course in Data Science & Machine Learning from Indian Institute of Technology (IIT), Delhi Work experience:- Designing of the database. Database Optimization. Writing Complex Stored Procedures,Functions,Triggers etc. Designing and developing SSIS & DTS packages. Designing SQL Reports using SSRS. Database Server Maintenance. Certification:- MCTS: DA-100: Analysing Data with Microsoft Power BI MCTS: DP-300: Administering Relational Databases on Microsoft Azure Microsoft certified Sql DBA in Sql server 2008 (MCTS). Microsoft certified BI professional in Sql server 2008 (MCTS). Oracle certified profession DBA in ORACLE 10g (OCP) certified profession DBA in ORACLE 9i (OCP) My other publication Technical Blog:- Technologies with Vivek Johari Guest Author and Blogger at sqlservercentral.com

Related Post

Miscellaneous SQL Server

🎉✨ Happy New Year 2025! ✨🎉

Jan 1, 2025 vivekjohari
SQL Server

Database Partitioning in SQL Server

Dec 31, 2024 vivekjohari
SQL Server

What are the important python libraries?

Dec 31, 2024 vivekjohari
31 thought on “How to change the database collation”

  8. … [Trackback]

    […] There you will find 80114 additional Information on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

You missed

Career Coaching

How to Update Your Resume After a Career Break: A Strategic Approach

February 28, 2025 Megha No Comments
Career Coaching

The Importance of Soft Skills in the Modern Workplace

February 28, 2025 Megha No Comments
Career Coaching

Unlocking the Power of Resume Keywords: Your Guide to Standing Out

February 28, 2025 Megha No Comments
Career Coaching

Top 10 High-Demand Careers in India for 2025: Secure Your Future Today

February 28, 2025 Megha No Comments