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
learningdb SET SINGLE_USER WITH ROLLBACKIMMEDIATE
ALTER DATABASE
learningdb COLLATE SQL_Latin1_General_CP1257_CI_AS
learningdb COLLATE SQL_Latin1_General_CP1257_CI_AS
ALTER DATABASE
learningdb SET MULTI_USER
learningdb SET MULTI_USER
Pingback: รับทำ seo สายดำ
Pingback: engagement rings
Pingback: w.88.com
Pingback: Nightmare Market Exit Scam
Pingback: w88
Pingback: บริษัท ออล ครีเอตี้ แลนด์ จำกัด
Pingback: 바카라사이트
Pingback: Mazlo
Pingback: Website
Pingback: Home Inspection Champaign IL
Pingback: cbd
Pingback: Darknet Empire Market
Pingback: Crystal Meth
Pingback: Darknet Drogen
Pingback: bandar ceme online
Pingback: Stock Markets Keep Making New Highs But The System Implodes Gold Silver Rallying Soon
Pingback: roofing in forney
Pingback: pelangiqq
Pingback: indo qq
Pingback: bong88.com.vn
Pingback: www.parisqq1.site
Pingback: Seedsman Discount Code
Pingback: pasarqq
Pingback: 2015louisvuittonoutlet
Pingback: poker99 online
Pingback: 12 bet.com
Pingback: www.1poker99.com
Pingback: đăng ký fun88
Pingback: duratrans nyc
Pingback: Stocks and Gold Silver PreMarket TA for This Week
Pingback: https://www.klikdokter.com/