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

Re: Collation error

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

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