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 Newsgroups: comp.databases.ms-sqlserver Subject: Re: Collation error Date: Wed, 14 Dec 2011 23:53:52 +0100 Organization: Erland Sommarskog Lines: 28 Message-ID: References: <3308185.1868.1323796918597.JavaMail.geo-discussion-forums@yqxx6> <31307309.752.1323816495036.JavaMail.geo-discussion-forums@vbu12> <11607267.55.1323872608296.JavaMail.geo-discussion-forums@yqio4> 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="28657"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18SEui6lXbOJcvbruyayrAO" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:WKZQzZ6lcs3kqCXcMzpV5oNrkBs= Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:869 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