RE: MSSQL replication

2007-09-11 Thread James Smith
Ok, after much searching and finding lots of examples that didn't work, I found a solution. For future reference... USE exec sp_dropsubscription @publication = '' , @article = '' , @subscriber = '' , @destination_db = '' exec sp_droparticle @publication = '' , @article = '' That should do it,

MSSQL replication

2007-09-10 Thread James Smith
I have some MSSQL tables replicating from a database here in the office to our web server. I need to remove one of the tables from the replication process but can't figure out how to do it, anyone know? Please don't tell me I have to remove all subscribers them make the change and re-subscribe bec