I am running Windows 7 with SQL Server 2008 (SP1) and RMS (Retail Management System). When trying to 'Z' off a till I getthe following error can anyone help???Run Time error '-2147217900 (80040e14)'Cannot resolve the collation conflict between 'Latin1_General_CI_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation.Searching the web found a responce to set the database 'compatibility level' to 80 but it is already set to that!I had a previous error to that for 'Ad Hoc Distribution Queries' but that was resolved by running sp_configure.Thanks.

Hi, It seems this is SQL server related issue, since we have specific support for SQL server issues, to address this issue more efficiently, please post anew thread to our MSDN SQL Server Forum (SQL Server Database Engine) and our SQL support engineer will help you on this. Thanks. Nicholas Li - MSFT

ok thanks