Cannot resolve the collation conflict again. And again.

Hello I am using SQL Server 2008 R2 (@@VERSION: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Data Center Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor) ). Server uses SQL_Latin1_General_CP1_CI_AS collation while database uses SQL_Latin1_General_CP850_CS_AS one. Toad version is 6.5.0.3001.So I am receiving collation conflict error every 10 minutes or so while working with object explorer, table design and so on. Sometimes retrying helps. Sometimes it is a complete show-stopper. Operations that causes this error are so numerous that it does not make sense to list all of them here. It just looks like this program has never ever been tested in such environments. Last show-stopper: this table does not show its script:

Edit: this problem does not seem to reproduce in 6.6 Beta 516

Hi Anton,

correctly. In TOAD SS 6.6 beta the problem was fix.

For details : www.toadworld.com/…/23011.aspx .

Best regards,

Sergio