cannot resolve collation conflict for equal to operation

• Timothy Tan

  Valued Member

  Points: 66

  More actions

  May 9, 2008 at 8:33 am

  #71946

  Hi,

  When the server and database collation are not the same, "cannot resolve collation conflict for equal to operation" results when running a script through osql that invokes 'dbcc dbreindex ...'. But using ''xp_sqlmaint ... -rebldidx ...' works. What is sp_sqlmaint doing to handle this collation mismatch that causes my script run through osql to fail?

  Thanks and cheers,

  Tim

• Steve Jones - SSC Editor

  SSC Guru

  Points: 740241

  More actions

  May 9, 2008 at 9:09 am

  #813132

  That's strange. I wonder what it's doing as well. Profiler help at all or does it just show xp_sqlmaint?

• Timothy Tan

  Valued Member

  Points: 66

  More actions

  May 9, 2008 at 10:42 am

  #813228

  Hi,

  My apologies but I had a scripting error that prevented my script that runs DBCC DBREINDEX statements from running correctly.

  I caused my own problem. Sorry to have misled anyone.

  Tim