in

RichmondSQL

Richmond SQL Server Users Group

SQL Server Merge

Last post 11-24-2008 5:38 AM by dldeskins. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-19-2008 1:24 PM

    SQL Server Merge

    Hello, I am looking for a consultant. 

    I am a developer/admin with a MSSQL Server 2000 (SP4) on an inhouse machine with MS 2003 Business.  We have doing merge replication to ecommerce sites, with the same version of MSSQL. This was all originally set up by me.  All was well until i tried to delete a column with a store proceedure.  When it failed, I went into EM and deleted the column (Publisher > Properties >Filter Rows).  After I deleted the column, I expected the snapshot to rerun and merge to pick up again.  It not only failed, but deleted all the tables on the ecomerce site and tried to replicate them from the snapshot.  I went through several attempts to try to correct this problem, even at the last deleting the publisher and subscriber and starting all over.

    I really need some help with this.

    Don Deskins - Kingsport, TN

     

    Filed under:
  • 11-24-2008 5:38 AM In reply to

    Re: SQL Server Merge

     The merge is now up and running. 

     Thanks to Richard Todd for his help and support.

     

     

Page 1 of 1 (2 items)
Join Our Mailing List!

We've disabled the signup functions on this website. If you want to receive email updates about meetings and events, you need to join our new Mailing List!

Join Today!
©2006-2011 Richmond SQL Server Users Group; ©2008-©2011 Richmond User Groups Corporation
Powered by Community Server (Non-Commercial Edition), by Telligent Systems