Groups > comp.databases.ms-sqlserver > #863

Collation error

From	Lackey <lackeysc@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Collation error
Date	2011-12-13 09:21 -0800
Organization	http://groups.google.com
Message-ID	<3308185.1868.1323796918597.JavaMail.geo-discussion-forums@yqxx6> (permalink)

Show all headers | View raw

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!

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Collation error Lackey <lackeysc@gmail.com> - 2011-12-13 09:21 -0800
  Re: Collation error Erland Sommarskog <esquel@sommarskog.se> - 2011-12-13 23:32 +0100
    Re: Collation error Lackey <lackeysc@gmail.com> - 2011-12-13 14:48 -0800
      Re: Collation error Erland Sommarskog <esquel@sommarskog.se> - 2011-12-14 08:22 +0000
        Re: Collation error Lackey <lackeysc@gmail.com> - 2011-12-14 06:23 -0800
          Re: Collation error Erland Sommarskog <esquel@sommarskog.se> - 2011-12-14 23:53 +0100
    Re: Collation error Lackey <lackeysc@gmail.com> - 2011-12-13 14:53 -0800

csiph-web