Solomon Cloud Solutions

  • Services
  • Software Solutions
    • Beyond Software
    • Dynamics SL >
      • Account Central
      • All-In-One Project Invoice
      • Audit Utility
      • Mobile Time and Expense
      • Notifications
      • Project Invoice Posting Selection
      • Salesforce Integration
      • Transaction Import Automation
      • Two Factor Authentication
      • Web Apps Reports
      • Web Apps ROI Scheduler
    • Strategic Partners
  • Partner Portal
  • News & Events
  • About Us
    • Board of Directors
    • Careers
    • Community
    • Our History
    • Mission & Values
    • Testimonials
  • Contact Us
  • Services
  • Software Solutions
    • Beyond Software
    • Dynamics SL >
      • Account Central
      • All-In-One Project Invoice
      • Audit Utility
      • Mobile Time and Expense
      • Notifications
      • Project Invoice Posting Selection
      • Salesforce Integration
      • Transaction Import Automation
      • Two Factor Authentication
      • Web Apps Reports
      • Web Apps ROI Scheduler
    • Strategic Partners
  • Partner Portal
  • News & Events
  • About Us
    • Board of Directors
    • Careers
    • Community
    • Our History
    • Mission & Values
    • Testimonials
  • Contact Us

Dynamics SL Database Collation Repair

In the event of your database collation being modified, we can assist in fixing the issue.


Microsoft does not recommend changing the collation of data for Dynamics SL customers. In the event the database collation was modified in your Microsoft Dynamics SL database, Solomon Cloud Solutions provides a three-step process to fix the database collation:

  1. Assess what default database collation is in place on the SQL Server.
  2. Assess what database collation is in place for the Dynamics SL specific databases.
  3. Define the proper way to change the database collation to the Microsoft supported collation, apply the changes to the database, and ensure the databases function properly within Dynamics SL after the change is complete.

Database collation serves two important roles:

  1. It defines the rules SQL Server applies when sorting and comparing characters in a database.
  2. It defines the underlying code pages used to physically store non-Unicode data (e.g., column types of char, varchar, and text).

The rules, that SQL Server applies when sorting and comparing characters, are strongly related to the language associated with the data. They can also specify other sorting or comparison behaviors, such as whether the sort or comparison operation is case-sensitive (_CS), case-insensitive (_CI), accent-sensitive (_AS), accent-insensitive (_AI), or width-sensitive (_WS).

​Get in touch with us today for more information!

Have questions about a service? Let us know!

    First, Last Name
Submit
HOME     |      ABOUT     |    TESTIMONIALS     |      SERVICES     |     SOFTWARE     |     PARTNER PORTAL     |     NEWS & EVENTS      |      CONTACT US
©​ 2025 Solomon Cloud Solutions 

SOLOMON CLOUD SOLUTIONS and SOLOMON SOFTWARE  are trademarks or registered trademarks of Plumbline Solutions, Inc. in the U.S. and other countries.