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

    Exclamation Unanswered: SQL Server 2005 Management Studio

    Hi,

    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!

    Javu

  2. #2
    Join Date
    Oct 2007
    Posts
    35
    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
  •