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

Re: Collation error

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From	Lackey <lackeysc@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Collation error
Date	Tue, 13 Dec 2011 14:48:15 -0800 (PST)
Organization	http://groups.google.com
Lines	17
Message-ID	<31307309.752.1323816495036.JavaMail.geo-discussion-forums@vbu12> (permalink)
References	<3308185.1868.1323796918597.JavaMail.geo-discussion-forums@yqxx6> <Xns9FBAEF6936983Yazorman@127.0.0.1>
Reply-To	comp.databases.ms-sqlserver@googlegroups.com
NNTP-Posting-Host	12.234.70.162
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
X-Trace	posting.google.com 1323816595 2537 127.0.0.1 (13 Dec 2011 22:49:55 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Tue, 13 Dec 2011 22:49:55 +0000 (UTC)
In-Reply-To	<Xns9FBAEF6936983Yazorman@127.0.0.1>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=12.234.70.162; posting-account=z_KmGQoAAADCs9Qy4bD3D0ykyBjotppG
User-Agent	G2/1.0
X-Google-Web-Client	true
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:865

Show key headers only | View raw

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'.

SELECT serverproperty('ProductVersion'), serverproperty('Collation'), 
       databasepropertyex(db_name(), 'Collation') 

Local machine result: 8.00.2055	SQL_Latin1_General_CP1_CI_AS	SQL_Latin1_General_CP1_CI_AS

Remote maching result: 8.00.2039	SQL_Latin1_General_CP1_CI_AS	Latin1_General_BIN

I am using SQL Server 2000 by the way.

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