830926b8   
   From: esquel@sommarskog.se   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)