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 08:22:39 +0000 (UTC) Organization: Erland Sommarskog Lines: 26 Message-ID: References: <3308185.1868.1323796918597.JavaMail.geo-discussion-forums@yqxx6> <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 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