indexing problem after implicit conversion in sql server 2005

Anoop 2013-10-16 14:35:37

Hi even though i have no mismatch of columns,sqlserver still does an implicit conversion.And my collation is SQL_Latin1_General_CP1_CI_AS.
This is resulting in full table scan rather than index seek.
I have a non clustered index on a column.
I have also tried changing the collation to Latin1_General_CI_AS.But there was no difference.
Please suggest me code fix to solve this issue.

SQLkiwi 2013-10-25 04:19:09
The anonymized plan shows nothing useful for us to help you with this issue. Please provide a repro script instead, together with a non-anonymized plan if that will assist us. In general, SQL Server will use a useful index if collations match.