Changing the database Collation

[derickab72]

I want to use both my Lansweeper and SCCM databases to build reports and cross reference the informaaiton. The SCCM databases collation is SQL_Latin1_General_CP1_CI_AS where Lansweepers is
Latin1_General_CI_AI. If i was to change the Lansweepers collation to match SCCM will it break the database?

[Hemoco · Accepted solution]

derickab72 wrote:

Latin1_General_CI_AI. If i was to change the Lansweepers collation to match SCCM will it break the database?

Yes, it will break, you will need to use a collate conversion function in your queries.