Mix collation settig impact
Is it possible to run SAP B1 in server that have different collation settings ?
Pls give advice
Jimmy Michael replied
I assume you have read the notes and I suggest to alter your collation setting to SQL_Latin1_General_CP1_CI_AS if the new database or old database collation is different with your new server collation and SBO_Common database collation. The query is:
alter database [<db name] collate SQL_Latin1_General_CP1_CI_AS