>Hi Sergey,
>
>Thanks for all your help you were dead right, the collation on our server is Latin1_General_CI_AS and their's is Latin1_General_BIN.
>
>From a longer term point of view we need to change our application to deal with this. From a short term point of view I was going to get them to change their collation on just the database we are accessing to Latin1_General_CI_AS. Do you know if there is anything that we need to take into consideration before implementing this short term approach?
>
>Thanks again for all your help its much appreciated.
>
>Jon

Check master,tempdb,model.... databases,
probably these and the server are set up to Latin1_General_BIN.
Therefore, every call to an object or identificatore must be exact

Example:

sp_Who -- this fail

Another point:
you can change from Latin1_General_CI_AS to Latin1_General_BIN,
but change Latin1_General_BIN to Latin1_General_CI_AS present more troubles
because you can have two objects with different names in Latin1_General_BIN collate,
but with the same name in Latin1_General_CI_AS collate.

Fabio