home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,539 of 19,505   
   Erland Sommarskog to Lackey   
   Re: Collation error   
   14 Dec 11 23:53:52   
   
   5a0b5cea   
   From: esquel@sommarskog.se   
      
   Lackey (lackeysc@gmail.com) writes:   
   > Create view FS_Customer as   
   >...   
   > from Mfg_CUSTMAST T1   
   >   
   > AS you can see, it is a pretty straight forward view.   
      
   And Mfg_CUSTMAST is a table and not another view?   
      
   Is there any computed columns in this table/view?   
      
   What I'm getting at is that the replace() operation mentioned in   
   the error message must be hiding somewhere. It cannot come out of   
   the blue.   
      
   Meanwhile, the query for linked servers on SQL 2000 is:   
      
   select srvcollation, useremotecollation, collationcompatible   
   from  master.dbo.sysservers   
   where  srvname = 'SQL-STL'   
      
   --   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca