Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Collation error

Show all headers | 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