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'
RichardsoetAsked:
Who is Participating?
 
MrNeticConnect With a Mentor Commented:
Richardsoet,

Better to use the Following:

Drop Table tb_useractivitylog

Best Regards,

Paulo Condeça
0
 
RichardsoetAuthor Commented:
i don t want to drop the table from database , just to drop it from merge replication articles
0
 
RichardsoetAuthor Commented:
Server: Msg 3724, Level 16, State 2, Line 1
Cannot drop the table 'tb_useractivitylog' because it is being used for replication.
0
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.

All Courses

From novice to tech pro — start learning today.