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

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 08:22:39 +0000 (UTC)
Organization	Erland Sommarskog
Lines	26
Message-ID	<Xns9FBB5F653BE3AYazorman@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>
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
Injection-Date	Wed, 14 Dec 2011 08:22:39 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="G7+Jz22XqYCG8C6rb1H3YA"; logging-data="20886"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+r2NGYDmjm7xWUrY6YrSUn"
User-Agent	Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32)
Cancel-Lock	sha1:xPIaSGcpagsImwc8WnUU1Ny7XoI=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:867

Show key headers only | View raw

Lackey (lackeysc@gmail.com) writes:
> Thanks for your help. Here are the results:
> 
> SELECT is_collation_compatible, uses_remote_collation, collation_name 
> FROM   sys.servers 
> WHERE  name = 'SQL-STL' 
> 
> Result:Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'sys.servers'.

Moral: always say which version of SQL Server you are using up front. 
Particularly if you are still on SQL 2000. :-)

The settings I'm asking for are available on SQL 2000 as well, but I 
don't on the top of my head to find the information.

In the meanwhile, can you post the view definition?

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

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