.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

Change merge subscription sync_type

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

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.


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

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

Change the format of List Alert subscription Notification


When we subscribe to any list item for alerts we get an email message for confirmation of successfull subscription.


the email  looks like below :


Subject : You have successfully created an alert for 'Team Discussion: Topic 1


Body ;

Alert 'Team Discussion: Topic 1' has successfully been added on 'Test Site'.

You will receive alerts in e-mail. The timing and criteria for the alerts depend on the settings entered when the alert was added.

You can change this alert or any of your other alerts on the My Alerts on this Site page.


I wish to change the format of this email. Any Inputs ??


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?




Merge Subscription can not be dropped


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

How to Localize Windows Forms and Change the Language at Runtime

Localization is the process of customizing your application to a particular language, culture or locale. Visual Studio provides support for localizing Windows Forms with much ease. In this article, we will see how to localize windows forms and give the user the ability to change to his preferred language at runtime.
When you run a localized application, the appearance is determined by two culture values. The UICulture property is used to specify which resource files will be loaded for the form. The Culture property, on the other hand, determines how strings such as dates, numerals, and currency amounts are formatted.
Let us see the steps required to create a localized form. You can then expand this example and adopt the same approach for the rest of the forms in your project

Selected to change the background color of the page



As this site, http://www.borfin.com.tr/genel/Default.aspx, How can I change the background color selected pages.

Bug: Does not change column type from nvarchar to ntext


Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.

Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.

How to change the default page base class?


I've tried setting the <pages pageBaseType="DynamicWebPage" /> value in web.config, but when I response.write out the page type, I'm still getting Microsoft.WebPages.WebPage.

I'm simply trying to sub-class WebPage and add some additional functionality such as a dynamic PageData dictionary similar to Phil Haack's dynamic ViewData dictionary.



SqlDataSource how to change the stored procedures at run time



Is it possible to change the select, insert and update stored procedure of an SqlDataSource at run time. I don't mean to change the definition of the stored procedure, but I mean to change the assignment, i.e. To change the select stored procedure from "selectSP1" to "selectSP2" at run time. Is it possible?



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