<div>
post the sp_help_revlogin_db source or findout the columns used in the joins and make sure charset/collation of all the columns same.<br />
or use collate clause to change both the columns to one collation in your sql
</div>


post the sp_help_revlogin_db source or findout the columns used in the joins and make sure charset/collation of all the columns same.
or use collate clause to change both the columns to one collation in your sql

<div>
<div class="content wysiwyg-content">
I ran my sql scripts &nbsp;and it return me below error, how do I fix this collation problem ?<br />
<br />
Msg 468, Level 16, State 9, Procedure sp_help_revlogin_db, Line 20<br />
Cannot resolve the collation conflict between &quot;SQL_Latin1_General_CP1_CI<wbr />_AS&quot; and &quot;Latin1_General_CI_AS&quot; in the equal to operation.<br />
Msg 468, Level 16, State 9, Procedure sp_help_revlogin_db, Line 27<br />
Cannot resolve the collation conflict between &quot;SQL_Latin1_General_CP1_CI<wbr />_AS&quot; and &quot;Latin1_General_CI_AS&quot; in the equal to operation.
</div>
</div>


I ran my sql scripts  and it return me below error, how do I fix this collation problem ?

Msg 468, Level 16, State 9, Procedure sp_help_revlogin_db, Line 20
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure sp_help_revlogin_db, Line 27
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

collation issues

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.