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