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

Re: Collation error

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 <esquel@sommarskog.se>
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	<Xns9FBBF31A66B28Yazorman@127.0.0.1> (permalink)
References	<3308185.1868.1323796918597.JavaMail.geo-discussion-forums@yqxx6> <Xns9FBAEF6936983Yazorman@127.0.0.1> <31307309.752.1323816495036.JavaMail.geo-discussion-forums@vbu12> <Xns9FBB5F653BE3AYazorman@127.0.0.1> <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

Show key headers only | View raw

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

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