Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    60

    Unanswered: Snap shot replication failed. Could not drop table.

    Do replicated tables at the subscriber retain PK-FK relations. The subscriber to a publication is saying the push failed because it, "Could not drop object 'tablename' becuase it is referenced by a FOREIGN KEY."

    How do you get around this?

    Any help would be appreciated.

    Mike

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Use ALTER TABLE to drop any constraints, you can use PROFILER to see the activity during this process.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2003
    Posts
    60
    Originally posted by Satya
    Use ALTER TABLE to drop any constraints, you can use PROFILER to see the activity during this process.

    Thanks will give it try.

    Mike

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to BOL for ALTER TABLE>.. topic information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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