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

Re: Collation error

From	Lackey <lackeysc@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Collation error
Date	2011-12-13 14:48 -0800
Organization	http://groups.google.com
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>

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