1 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Batch Update - JNCCDel5

Not only can the addin not delete a survey, it seems the batch update is having problems as well:

There is an error in the SQL code. The error message is: 'Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_C1_AS" in the equal operation'

Any ideas?

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

2 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Batch Update - JNCCDel5

This is an error message that can occur when you use the MSDE/ SQL Server 2000 version of a batch update in SQL Server Express/ SQL Server 2005. In the latter, COLLATE clauses are required in CREATE TABLE statements. These govern the way comparisons are done. The default used by MSDE is the required option but 2005 uses a different default so the COLLATE clause is needed to get comparisons done in the right way. You will find the SQL Server 2005 version of the batch update in the v6.14.4.212 upgrade.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687