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.