Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / How to change server c...
Microsoft Dynamics RMS (Archived)

How to change server collation in Microsoft store operation Administrative

(0) ShareShare
ReportReport
Posted on by Umar Khitab 750

Dear's All.

I want to change the server collation in Store Operation Administrative. Can any body help me that how can i change the server collation after that my Databas collation and server collation will b same and there will be no conflict error is coming.

Please Help me as early as possible.

Thanks

Umar Khitab

*This post is locked for comments

  • Umar Khitab Profile Picture
    Umar Khitab 750 on at
    Re: Re: How to change server collation in Microsoft store operation Administrative

    Thank you very much to give me such a good answer.

    I can rebuild the master database and during rebuilding of master database I can change my server colation.

    Thanks again.

    Umar Khiab

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How to change server collation in Microsoft store operation Administrative

    Hi, I find this from Microsoft

    "--------------------------------------------------------------------------------------------------------------

    Changing the default collation for an instance of SQL Server can be a complex operation and involves the following steps:

    • Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them.
    • Export all your data using a tool such as the bcp Utility. For more information, see Importing and Exporting Bulk Data.
    • Drop all the user databases.
    • Rebuild the master database specifying the new collation in the SQLCOLLATION property of the setup command. For example:
      Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName 
      /SQLSYSADMINACCOUNTS=accounts /[ SAPWD= StrongPassword ] 
      /SQLCOLLATION=CollationName
      For more information, see Rebuilding System Databases.
    • Create all the databases and all the objects in them.
    • Import all your data.

    " --------------------------------------------------------------------------------------

     

    thank you

    Mohammed El Qadi

    http://www.fact.fm/viewforum.php?f=30

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans