Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007

    Exclamation Unanswered: SQL Server 2005 Management Studio


    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)

    Please help!


  2. #2
    Join Date
    Oct 2007
    That operation is not allowed/availble on a linked server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts