I'm going to be restoring some databases with a binary collation onto a server with a different collation and want to find out what possible problems I might encounter so I can mitigate them.
The only problem I can see at the moment is problems with temp files and if you use the temp file it will be created with the collation of the server it's running on so I would need to correct this by using collate statements in the SPs.
Does anyone know of any other considerations that I would need to take into account?
Thanks