Extended Properties

• Warwick Rudd

  Ten Centuries

  Points: 1240

  More actions

  September 13, 2006 at 12:12 am

  #114788

  Currently we use the Extended properties and I am in the process of trying to sync environments up. I have found that the main differences are that the Extended properties have not been set.

  I have put together a script which is able to work through the objects in both environments and compare the Extended properties that i am interested in.

  Due to the number of objects and having to check each one and update appropriately i am using a cursor to work my way through. Once i have determined the appropriate values to update the extended properties. At this point in the cursor i try to update but i receive the following message - 'Remote tables are not updatable. Updatable keyset-driven cursors on remote tables require a transaction with the REPEATABLE_READ or SERIALIZABLE isolation level spanning the cursor.'

  If someone can explain why this occuring and maybe a way around it or a better way of doing this i am open to suggestions.

  Thx

  MCT
  MCITP Database Admin 2008
  MCITP Database Admin 2008
  MCITP Database Dev 2008
  www.jnrit.com.au/Blog.aspx

• peterhe

  SSChampion

  Points: 11469

  More actions

  September 14, 2006 at 6:49 am

  #660355

  Try to set the transaction isolation level to SERIALIZABLE in the beginning of your script:

  SET TRANSACTION ISOLATION LEVEL SERIALIZABLE