
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-08-2014 11:20 PM
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?
Latin1_General_CI_AI. If i was to change the Lansweepers collation to match SCCM will it break the database?
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2014 10:51 AM
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.
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2014 10:51 AM
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.
