Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    2

    Question Unanswered: Problem deleting

    I have a sick subscriber in a transactional replication.
    I want to delete it but I don't succeed.
    When I try from Tools\Replication\Create and manage publications Entreprise Manager crush.
    I try with
    exec sp_dropsubscription @publication = N'PublicationName', @article = N'all', @subscriber = N'SubscriberName', @destination_db = N'DatabaseName' but execution take a long, long time ..without any end.
    I don't want to delete all replication.
    Any ideeas?
    10x a lot!

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Whats the size of Subscriber?
    Check for any other errors from SQL error log.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2003
    Posts
    2

    Thumbs up

    In the end I deleted all replication and recreated it. Now it's working.

Posting Permissions

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