Hello again, think I have got to the bottom of this now. Although the default language is the same on both servers (ENGLISH). The logins are set differently...

Thanks for your help. I have checked sp_configure 'default language' on both servers and they are identical and the collations are also identical so I assume this makes the...

Thanks,  I'll  bear  that  in  mind.    Could  call for  a change  in  our  standards!

All of our user created stored procedures are prefixed sp_ and this doesn't confuse us at all.

It seems that if you have multiple database on an instance, each database can be mirrored (even to different servers if desired).  It is possible for one database to failover and...

Thanks, very helpful. Still can't see anything on what triggers a failover and if one database on a server fails, will the whole server fail over (all databases).

Thanks  Barry,  I  will consider this as another option.      I  wasn't  aware  that  doing  this  would  convert  the  database  up  to  version  2005,  so  that  is  useful.    I noticed  that  the  Copy  Database  Wizard ...

Sorry for the delay.  Thanks for your suggestions, both of which are useful. 

Thanks, that is interesting.  The image here has been rebuilt 3 times so our Systems Admin team don't think it is a problem with the image itself (I'm not so sure...

Thanks for all the help.  It turns out that the problem was that 2 different middleware servers were being used here - one of which had been set up with different...

Thanks Very much. This has confirmed that the database and server collations are identical on both servers.  The regional settings are also identical on both servers. I can only assume...

Thanks very much.  I had an inkling that I might end up having to convert the 1's and 0's to the hex format that the SQL Binary data type understands,...

Thanks.  I have just tried the following

DECLARE @BinaryVariable binary (32)

SET @BinaryVariable = 00000000010000000010101111011101

SELECT @BinaryVariable

SELECT CAST( @BinaryVariable AS int)

The binary is stored as 0x00000000000000000000000000000000170000011D37628BEAD2E0191E020000 and when I cast this to int,...