Collation errors suddenly started occuring on SQL database!!!

[columbo2]

Hi all,
I've never come accross collation errors before but suddenly they've started happening on our database.
SCripts that I have stored and run on a regular basis now fail with errors such as
"Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict"
I had one script where, after looking around on the web, I added "COLLATE SQL_Latin1_General_CP1_CI_AS" to the where claus but now I'm looking at a far more complex script and I can't get it to work.

I've got two questions:

1. Can anyone think why the collation errors may have just started. They coincided with a call I had from the hosts saying they had to reboot the server...

2. Is there a way you can globally set the COLLAte statement for a whole script?

Thanks
C

 

[r937]

1. ask your host to tell you which version of the software they installed before the reboot

2. please post in the correct forum, this forum is for ANSI SQL

r937.com | rudy.ca