How to change the database collation

SQL Basic Concepts SQL Server
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

31 thoughts on “How to change the database collation

  1. Pingback: engagement rings
  2. Pingback: w.88.com
  3. Pingback: w88
  4. Pingback: 바카라사이트
  5. Pingback: Mazlo
  6. Pingback: Website
  7. Pingback: cbd
  8. Pingback: Crystal Meth
  9. Pingback: Darknet Drogen
  10. Pingback: bandar ceme online
  11. Pingback: roofing in forney
  12. Pingback: pelangiqq
  13. Pingback: indo qq
  14. Pingback: bong88.com.vn
  15. Pingback: www.parisqq1.site
  16. Pingback: pasarqq
  17. Pingback: poker99 online
  18. Pingback: 12 bet.com
  19. Pingback: www.1poker99.com
  20. Pingback: đăng ký fun88
  21. Pingback: duratrans nyc

Leave a Reply