web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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

     

  • Umar Khitab Profile Picture
    Umar Khitab 750 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans