• Hi GSquared,

    Yes sure, if it was for a production I'd have gone with microsoft directly. This is, fortunately, not a problem on productions as their databases have same collation as the server instance. I do restores from more productions on a test server , and the backups are coming with different collations. Moreover the test server is a virtual machine. I cannot make a system restore. I'll probably try with latest cumulative hotfixes for sql server 2008r2.

    Additionally, can someone tell me if this is resolved with sql server 2012 ?

    Thanks

    IgorMi

    Igor Micev,My blog: www.igormicev.com