Re: sp_dropmergearticle

Evan,
I'd script out the publication then drop it. Edit the script to not have the
article in it then recreate. Essentially you'll end up in the same
situation.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)




.

Relevant Pages

  • Re: Upsizing from Access doubles varchar columns
    ... 32 Ridley Road ... > in development and happy to drop and recreate everything then the ... > Tasks> Generate Script in Enterprise Manager), ... > design in Access will also be appropriate for SQL Server. ...
    (microsoft.public.sqlserver.programming)
  • Re: Need help with a security issue on MS SQL 2000
    ... You script out the permissions, drop the user, edit the script, and recreate ... SID, delete the new user, then manually edit the syslogins table. ... HIGHLY recommend you not do this. ... > the SQL server, it doesn't seem to pick up on the name change. ...
    (microsoft.public.sqlserver.security)
  • Re: Upsizing from Access doubles varchar columns
    ... This is trickier than it sounds because indexes ... in development and happy to drop and recreate everything then the ... Tasks> Generate Script in Enterprise Manager), ... design in Access will also be appropriate for SQL Server. ...
    (microsoft.public.sqlserver.programming)
  • Re: Delete table data
    ... It might be best to script out all the objects, drop the db and recreate it ... Just make sure to have a backup and make sure you script out all the ... > Is there any easy way to clear all table data for a SQL server database? ...
    (microsoft.public.sqlserver.setup)
  • RE: Merge Pub from 2005 to 2008
    ... The best you can do is script out the whole setup and remove replication then ... migrate the databases then edit the scripts and recreate the publications and ...
    (microsoft.public.sqlserver.replication)