LockedHot!how to change the sql server Database Collation.

Author
HMCGuru
Member
2019/04/16 06:00:14 (permalink)

how to change the sql server Database Collation.

Dear All,
 
Can some one tell me how to change the sql server database collation to some other. 
 
Kindly share the possible solution which might help us to solve this case.
 
Regard,
 
#1

1 Reply Related Threads

    HC Team
    Hosting Controller
    Re: how to change the sql server Database Collation. 2019/04/16 07:44:48 (permalink)
    You can change the collation of SQL Server with the help of instructions as mentioned in the link below but there is a caution that there is a caution that needs to be taken in consideration before changing the collation i.e. all databases are detached upon changing the collation of SQL Server and one has to re-attach them again as explained in this link below :
    https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-server-collation?view=sql-server-2017
     
    Note: You should perform the task of SQL Server collation first in test environment so you should know the exact steps prior to performing the steps on your production environment because all databases will be taken down for sometime due to this change of collation on the server.
    #2
    Jump to: