Path: csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From: Lackey <lackeysc@gmail.com>
Newsgroups: comp.databases.ms-sqlserver
Subject: Collation error
Date: Tue, 13 Dec 2011 09:21:58 -0800 (PST)
Organization: http://groups.google.com
Lines: 19
Message-ID: <3308185.1868.1323796918597.JavaMail.geo-discussion-forums@yqxx6>
Reply-To: comp.databases.ms-sqlserver@googlegroups.com
NNTP-Posting-Host: 12.234.70.162
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1323796918 27945 127.0.0.1 (13 Dec 2011 17:21:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 13 Dec 2011 17:21:58 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=12.234.70.162; posting-account=z_KmGQoAAADCs9Qy4bD3D0ykyBjotppG
User-Agent: G2/1.0
X-Google-Web-Client: true
Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:863

I can ussually resolve this issue but I'm looking for help this time. I'm running the following select statement on one server and pulling the information from a second server.

SELECT CustomerName
from [SQL-STL].FSDBPE.dbo.FS_Customer

Results: Server: Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.
Server: Msg 446, Level 16, State 1, Line 1
Cannot resolve collation conflict for replace operation.

The odd thing is I can run the following select statement without errors.

SELECT *
from [SQL-STL].FSDBPE.dbo.FS_Customer

Result: returns all fields including CustomerName

Thanks for your help!