.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Merge Subscription can not be dropped

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

Hi everybody,

I have a merge publication on server A and a push subscription on server B (as it is visible in the list of subscriptions in the treeview in SSMS under the publication.
When I try to remove the subscription by GUI i get the following error:

"B" is not definied as Subscriber for "A"
The subscription could not be dropped at this time
Changed database context to "pubdb" (Microsoft SQL Server, Error 20032)

OK - I know that sometimes this could happen - for any unknown reasons. But I'm familiar with T-SQL so I've decided to remove the subscription with sp_dropmergesubscription a la...

sp_dropmergesubscription @publication = N'dba', @subscriber = N'B', @subscriber_db = N'pubdb', @ignore_distributor=1

When I execute this statement I got the following error in the query window...

Msg 14055, Level 16, State 1, Procedure sp_dropmergesubscription, Line 70
The subscription does not exist.

That makes me puzzled because I see the subs

View Complete Post

More Related Resource Links

Merge Replication: Fails using Replication.SaveProperties when changing Subscription Info

I'm trying to use SQL Server/Compact Framework 3 Merge Replication functionality and am running into a problem when calling Replication.SaveProperties (using c#). I was hoping to get some clarification on whether its my interpretation on how things should work vs a coding problem. Basically, the Merge Replication seems to work as I can sync information between my handheld and server databases.  However, I've created a form on my handheld so that the user can change some synchronication settings (e.g. Publication or Publisher Name) and then save it.  What I've noticed is : 1) You can NOT call Replication.SaveProperties until after a synchronization is performed (otherwise you get an error message).  Assuming this is so that it can create the "__sysMergeSubscriptions" table. Does this sound right? 2) If I then try to change the saved Subscriber information via another call to Replication.SaveProperties (e.g. change the Publication info), I then get an error message that says: The subscription was not found. Publisher, PublisherDatabase, or Publication  could be incorrect. Is this normal behavior?  Does this mean that you can you NOT change subscriber information; only add or drop it? Thanks,  Ed

Another merge agent for the subscription or subscriptions is running, or the server is working on a

Hi All, Using Merge Replication over the web (https). Server is running SQL Server 2008, client using SQL Server Express 2008. I am getting these error messages while trying to synchronize, and it won't let me sync: {call sp_MSensure_single_instance (N'{459D0BBA-53EC-4F65-AF52-E7DA478841DA}', 4)} Another merge agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent. Can you please advice what can be done to fix. Do I need to kill a process in SQL Server?

Merge Replication, Push Subscription : The snapshot takes centuries to apply

Well, not centuries, except that the users are storming the gate. I'm trying to find how to get the snapshot moved to the subscriber and applied in a reasonable time. Last time was successful, but took 2 1/2 days to build the subscriber database from the snapshot. Hillary responded: Something is very wrong here. You should be able to generate your snapshot, copy it manually over to the subscriber - using the altsnapshotfolder parameter and then apply it there. So now I have my snapshot, a folder with lots of .cft .bcp .dri .prc .sch  and .trg files. Getting this to the subscriber computer shouldn't take long. Once I get it there, how do I use it to get the subscriber set up?  You can't be successful at this unless you're at least 1/2 a bubble off level.

Can't get merge subscription to start pulling changes

Hello! We have two servers running SQL Server 2008 Standard.  I am using merge replication to replicate the entire database (11 GB, 350 tables) from Server 1 to Server 2 (pull subscriptions).  I have all the tables split up in about 10 publications.  I need about half of the database to be continuously updated every second, however, when I view the details of some of the tables in Replication Monitor I see a Download/Upload Progress bar that never gets to 100% and has an approximate time that keeps increasing.  I assume I/O is the bottleneck, so to test this theory I wanted to setup subscriptions on a new server we’ll be using for another project – which has a PCIe SSD (running SQL Server 2008 R2).  When I view the synchronization status on the subscriber (new server), I get the message:   “Skipping file TableName.sch' because it has already been delivered for a previous article or by a previously interrupted snapshot.” In Replication Monitor, the status is Running and the message in the Error Message column changes the table name (and script applied) in the message “Bulk copying data into table ‘DifferentTableName’”.  But the table names and scripts keep repeating themselves.  In the Error Messages field at the bottom of the window, I get: “The process was successfully stopped. (Sou

Initializing a Merge Subscription Without a Snapshot - doesn't operate correctly



I do the backup from the publisher, next I restore it at the subscriber using *pure* database.

next I attempt to create subscription using this db. of course, I use

SubscriptionSyncType.None for SyncType propery of the subscription.


1. nevertheless the merge agent downloads whole snapshot!

both data (bcp files) and the schema.

2. I get the *strange* error. below thelines from the log:

Applying the snapshot to the Subscriber

A dynamic snapshot will be applied from 'C:\DOCUME~1\...\LOCALS~1\Temp\DB$MAIN_DB1_Main_testReplFromBackup\'

Preparing table '__UserSyncOptions' for merge replication

Applied script '__UserSyncOptions_2.cft'

{call sp_MSsetconflicttable (N'__UserSyncOptions', N'MSmerge_conflict_Main___UserSyncOptions', N'DB\MAIN', N'DB1', N'Main')}

{call sp_MSsetconflicttable (N'__UserSyncOptions', N'MSmerge_conflict_Main___UserSyncOptions', N'DB\MAIN', N'DB1', N'Main')}

Incorrect syntax near 'Id'.

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When trou

Mysterious Subscription - Merge Replication


Hi. I have SQL Server 2005 Standrad Editions publisher and 3 subscribers.

I had a publication with 3 subscriptions. For some reason i had to delete one of the subscription.

At the time of deletion for the first time on the publication server, it didnot return any errors.

Then when i tried to recreate it at the publisher, it gave me message that it already exists.

Now when i try to delete it at the publisher (both by seleting the check box to connect to subscriber n deleting or unchecking the check box), it fails saying there is no such subscriber.

I can go to the subscriber server, under replications and subscritpuions, i can delete it. But after few minutes or so, it shows up again automatically.

In replication monitor i donot see that particular subscription under the publication

In the Distribution database, i donot see the entry of the subscriber in MSmerge_subscriptions table

But in the database on which replication is taking place, i do see the jargon entries of the subscriber in the System table sysmergepublications.

When i delete those entries with delete statements, they show up again in the table after a few minutes.


I ran SQL server profiler to try and understand whats happening. My suspect is its something to do with the execution of the

Change merge subscription sync_type


I have merge subscription created from backup but I want that new article add to publication after subscription creation would be propagated like with sync_type automatic. Is there are way to do this.

Thanks in advanced.

Now each time I add new article I need to manualy transfer table to subscriber.


How to initialize merge subscription locally?


This is the scenario that I'm trying to get working:
1) Publisher = SQL 2008 SP2, Subscriber = SQL 2008 Express, Replication = merge replication (pull) + subscribers get filtered data with Host_Name()
2) When a new subscriber connects to the publication, the publisher will generate a compressed snapshot
3) I will then manually download the compressed snapshot via passive FTP-SSL (as far as I know, merge replication only works with active FTP, please correct me if I'm wrong)
4) Once the snapshot is downloaded, I will perform the initial syncrhonization and apply the snapshot locally from the downloaded cab file

I'm having a problem with the last step in my scenario. I'm getting this error:
You cannot specify an alternate snapshot folder (-AltSnapshotFolder) or the partitioned snapshot folder name (-DynamicSnapshotLocation) when the publication has one or more articles that use non-overlapping partitions that are unique for each subscription (@partition_options = 3).

All the information that I have found on the web, suggests that this scenario is possible. Although for step 3, a removable drive (cd/dvd, usb drive) is suggested instead. But detailed information for step 4 is nowhere to be found.

As for the error itse

merge replication Uninitialized subscription warning


I've followed the instructions to setup merge replication. Finally, when I viewed the "Launch Replication Monitor", it is showing the warning as "Uninitialized subscription" Doesn anyone know the cause of this warning? Also, the table is not getting update,,,,,


Does Sync Center support for SQL Server 2008 R2 Express Edition pull merge subscription?



I have create a subscription (pull, merge replication) on SQL Server 2008 R2 Express Edition to a publication on SQL Server 2008 R2 Enterprise Edition. I have seen that the subscription has been enabled for Windows Sychronization Manager as I can see in its property dialog. However, I cannot see it in the Sync Center of Windows 7 on the Subscriber.

Does Sync Center support in this scenario? From another thread, it seems we need to use Windows Task Manager. If so, how can I set it up?

Thanks in advance.

Please mark replies as helpful or answers if they are helful, doing so can help others encountering the similar issue.

Merge Replication - Subscription Error


Hi All,


I get this error when I try to run the sync on a subscription. I found that this actually has something to do with permissions.

“ String or binary data would be truncated. [SQLSTATE 22001] (Error 8152). The step failed

If the account I am using is a server sysadmin does it still have to be part of the db_owner in publication and distribution dbs as shown below? It has write access to the file share as well so I am not sure I understand what the problem is? It is also a sysadmin on the client where the subscription is going?




Mail Merge




I am after creating a mail merge documents from datasource and .dot template file on server side. Can you give me an idea how i will achive this?


Thanks in advance.



Syed Hussain



Merge SQL to Excel--Need .Net button to open on fly and have current SQL data!


           Hello all,
I do not know if this is the proper place to ask this, but my question is...
I have a SQL DB and I want to convert it to Excel Sheet (I did this using the wizard)!
In my aspx page I have a button.  So when I press this button I want the Excel sheet to open!  But I need the Excel sheet to show me the up to date information that is in the SQL DB.  

Is Conditional Subscription possible in SSRS 2005?


Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???


How to merge 3 separated color (Red, Green and Blue) saved as grayscale images images into colored i


Hi friends, I have separated Red, Green and Blue color from a bitmap image and stored it in grayscale (obviously).  Now I want to know how can I merge it so that I can get the exact previous colour, when I am merging them by reading its color values but it is giving  me grayscale image :( . Please help me out with some working sample code. Thanking in anticipation.

I am using the following code:

 public bool mergeToRGBandWriteBitmap(string sourceRFile, string sourceGFile, string sourceBFile, string targetFile)
            bool isSuccessfullywritten = false;
                Bitmap bitmapRed = (Bitmap)Image.FromFile(sourceRFile);
                Bitmap bitmapGreen = (Bitmap)Image.FromFile(sourceGFile);
                Bitmap bitmapBlue = (Bitmap)Image.FromFile(sourceBFile);
   Bitmap afterMerge = mergeRGB(bitmapRed, bitmapGreen

merge word document



I recently created a team site on the SharePoint for projects management and our team will use the word document for inserting the information about the project that they work on it,

My case is:

for each project have multiple documents and i created a user control by VS.2005, this user control contain a drop down list contain all projects and merge button, when the user choose any project and click merge i will use the Work dll to merge all document that related to the project and export to the user.

This is my code

private void mergeDocument()


ApplicationClass WordApp =

How to increment default dates in the subscription


I have a report that I want run on a monthly subscription, but the report has a default date parameter. Is there a way to have the default date parameter increment each month. So if I choose to receive the subscription monthly I would want that default date to increment.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend