• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • Last Modified:

Merge Replication SQl2000

Am trying to drop a table called 'tb_useractivitylog' on my database using the below script
Error :

Server: Msg 208, Level 16, State 1, Procedure sp_droparticle, Line 81
Invalid object name 'syspublications'.

please help

exec sp_droparticle @publication = 'MotivanoUKLiveCoreReplication'
, @article = 'tb_useractivitylog'
  • 2
1 Solution

Better to use the Following:

Drop Table tb_useractivitylog

Best Regards,

Paulo Conde├ža
RichardsoetAuthor Commented:
i don t want to drop the table from database , just to drop it from merge replication articles
RichardsoetAuthor Commented:
Server: Msg 3724, Level 16, State 2, Line 1
Cannot drop the table 'tb_useractivitylog' because it is being used for replication.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now