Cannot resolve collation

Trying tun a script that updates a table and i get the
following error
'Cannot resolve collation conflict for equal to operation.'
Any ideas what causes this?Probably different collations between your system databases and the
application database. Either make sure that the databases has the same
collation or adjust the offending query and specify which collation the
query is to use (using the COLLATE clause).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"mat" <anonymous@.discussions.microsoft.com> wrote in message
news:b7b501c40815$73fe2f30$a301280a@.phx.gbl...
> Trying tun a script that updates a table and i get the
> following error
> 'Cannot resolve collation conflict for equal to operation.'
> Any ideas what causes this?