Different Collation on SQL Server and NAV 2015 DB

DrittesKnie
DrittesKnie Member Posts: 2
edited 2015-07-30 in SQL General
Hello.

We have a SQL 2014 Standard Server installed with a NAV 2015 database installed on that.
The SQL 2014 Standard Server has the following SQL collation: SQL_Latin1_General_CP1_CI_AS
The NAV 2015 database has the collation: Latin1_General_100_CS_AS

To set the SQL 2014 Server to the same collation as the NAV database, simple way is the recreate the SQL Default databases and thereby set the new collation as same as NAV database.

Question: uses NAV only the own NAV database? Or uses NAV also Default databases from SQL (e.g. temp) to operate?

Thank you for your assistance / your best practise for that.

Best regards,
Lars

Comments

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    NAV does not use tempdb directly (ie it does not issue any statements against tempdb), but it does use master db (license is usually stored in master db)

    BTW There is not such a thing as default db in SQL Server - I guess you refer to model db. If so changing default SQL Server collation takes a bit more than just recreating the model db. https://msdn.microsoft.com/en-us/library/ms179254.aspx

    Regards,
    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • joshuasung
    joshuasung Member Posts: 37
    You talking about that one?
    That's default NAV uses
    Joshua H Sung

    Sr. Project Manager
    S-Metric, LLC
    jsung@smetric.com

Categories