Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table can't be added to replication job

Status
Not open for further replies.

bombplayer

Programmer
Joined
Jul 3, 2001
Messages
47
Location
US
When trying to add an article (table) to a replication job, the server hangs and locks the table down. The table only has 20 rows in it so it's not a size issue. I try and use the wizard and the server locks the table and won't finish. When using sp_addarticle in query analyzer, the query runs indefinitely unless it is stopped.

Any help would be appreciated
 
Does the replication have any subscribers currently?
 
No. The replication was dropped and deleted last week. I am trying to bring it back online. All subscriptions were also dropped
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top