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

Re: Collation error

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Collation error
Date	Tue, 13 Dec 2011 23:32:06 +0100
Organization	Erland Sommarskog
Lines	45
Message-ID	<Xns9FBAEF6936983Yazorman@127.0.0.1> (permalink)
References	<3308185.1868.1323796918597.JavaMail.geo-discussion-forums@yqxx6>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx04.eternal-september.org; posting-host="nBFDv6s1VJQDuF1w6hpX2A"; logging-data="26077"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18ZRsVJ81Kl7zv7v5MyfOSD"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:qQkvUhqfzt7j1Yuip0JkduqwVMQ=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:864

Show key headers only | View raw

Lackey (lackeysc@gmail.com) writes:
> 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

Interesting. 

Is FS_Customer.CustomerName a physical column, or is it a computed 
column in a table or a view?

Can you post the output of the following queries:

SELECT is_collation_compatible, uses_remote_collation, collation_name 
FROM   sys.servers
WHERE  name = 'SQL-STL'

SELECT serverproperty('ProductVersion'), serverproperty('Collation'),
       databasepropertyex(db_name(), 'Collation')

Please run the latter query both in the local database and in 
the remote database.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | 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