federalised view not updatable after bcp into compounded tables

• tandrei

  SSC Veteran

  Points: 211

  More actions

  May 31, 2005 at 4:43 am

  #167056

  Hi guys,

  I have a federalised view over several tables, each containing monthly data. I had to do some bcp into one of this tables. After this, I cannot anymore insert data through the view, getting this "view is not updatable" error. PLease help

  andrei

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  May 31, 2005 at 11:55 pm

  #562075

  I suspect that the BCP operation changed the table relationships from a 1 to 1 to a 1 to many relationship which is what the view error suggests.

  Do a Select on the view and check for duplicates.

  Andy