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

Re: Collation error

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Collation error
Date	2011-12-14 23:53 +0100
Organization	Erland Sommarskog
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>

Show all headers | 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