Re: can U solve my problems?

Hello,

Sounds like you have two different servers with differing collations set? I
googled with the exact error message you have given and got some links.
Those should be able to get you going.

Hth,

brian
--
Got a big event coming up? Let us
help coordinate your event. For more
visit www.kissemgoodbye.com


"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@xxxxxxxxxxxx> wrote in message
news:42ba8e61@xxxxxxxxxxxxxxxxxxxxxxxxx
> I execute this syntax in Query Analyzer.
>
> SELECT * FROM TB1
> WHERE NO_ID IN (SELECT NOID FROM TB2)
>
> In the past, I always executed this syntax, and it's ok. But now, I get
> error message:
>
> Server: Msg 446, Level 16, State 9, Line 1
> Cannot resolve collation conflict for equal to operation.
>
> Why is it happended? And how to solve its problem?
>
>


.

Relevant Pages

  • Re: blue screen
    ... Enquire, plan and execute ... Background information on Stop Error message ...
    (microsoft.public.windowsxp.general)
  • RE: Need Help on Define Names
    ... The error message is "Compile error: ... are in the workbook, execute the rest of code. ... Dim NameMatch As Boolean ...
    (microsoft.public.excel.programming)
  • Re: Removing and event from the html code.
    ... Like I said earlier I inherited this script with the page. ... Actually I don't get an error message, ... > This assigns the *result* of running countdown to window.onload. ... window.onload won't execute until the page has fully loaded. ...
    (comp.lang.javascript)
  • RE: Unbound Combo Box Default Value Based on Query
    ... "ScottMsp" wrote: ... I am still getting error message, "The syntax of the subquery in this ...
    (microsoft.public.access.formscoding)
  • Re: LaTeX2rtf not running
    ... Cannot execute C:\PROGRA~1\LATEX2RTF\LATEX2RT.EXE ... Please cite exactly the complete error message ... probably related to window, not to latex2rtf. ...
    (comp.text.tex)