I have created two instaces on the Database Engine and have managed to also create a linkedserver between the two instances.
Now I'm trying to query two tables from both instances and I'm getting a collation conflict error. I tried to change this on the Database's propertry to match the other one, but still getting an error, see below:-
Database could not be exclusively locked to perform operation. ALTER DATABASE FAILED. The default collation of database"XXXX" cannot be set to ....(Microsoft SQl Server, Error : 5030)