How to ignore collation setttings

[ikirkland]

Is there any way to ignore collation settings when you are running a query over 2 databases??

i.e.

select * from PTS_SRV.PTS_staging.dbo.securityrg
where FirstExternalSecurityCode in
(
select assetSEDOLCode from ODSSRV.ODS.dbo.asset
)


Produces the error:

Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.

 

[danceman]

Are the fields identical in size, data type and the type of collation between the two databases. You are going to have to chat with the database adminstrator to look at how the code pages are in the databases. Attitude is Everything