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
Share this:
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
… [Trackback]
[…] Here you can find 341 more Information to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Find More on on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More Info here on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More here to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More here on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More here to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More here to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] There you will find 80114 additional Information on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Information to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More Info here to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More Information here on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More here to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Find More Information here to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Here you will find 68737 more Information to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Find More on to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Here you will find 7104 additional Information to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Find More on on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] There you can find 22573 additional Information to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More Info here on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More here to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Here you will find 21024 additional Info to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Find More here on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More on on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More Info here to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More Information here to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Read More Info here to that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]
… [Trackback]
[…] Here you will find 19540 more Info on that Topic: techmixing.com/2012/01/how-to-change-database-collation.html […]