I have 3 table t1, t2, and t3 as shown below. (Field of idofT1 in t2 and t3 related to t1.id)
View Complete Post
I have a problem with geography data type replication. Any change that is done on a Geography column breaks the replication - the error message is "The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the
article at the Subscriber." I double checked compatibility settings that is suggested here:
http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d8e31621-5d43-48cd-bdd3-c02b8a24625c. But both publisher and subscriber are 100RTM.
I checked synchronization logs and found a strange message - attempt to convert varchar to geography. I don't understand from where the varchar data type comes from. Tables at subscriber and publisher has the same format - geometry stored in geography data
2010-09-20 18:36:22.499 The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart
the Merge Agent to apply the DDL changes and synchronize the subscription.
2010-09-20 18:36:22.845 Category:NULL
Source: Merge Replication Provider
how to merge two columns of a table using SSIS.
eg. EMPLOYEE.FIRSTNAME and EMPLOYEE.SURNAME to EMPLOYEE.FULLNAME
Environment: MSSQL standard edition – 2008 / Windows server 2008 (64 bit)
I have lots of tables with merge publication (filtered) on windows 2008 server and it takes few seconds to insert/ delete single row on that database.
This is what execution plan shows.
Delete single row: 7 sec. It shows 47 queries.
Insert single row (2 columns): 4 sec. 35 queries.
What I can see it
MSmerge_past_partition_mappings and MSmerge_current_partition_mappings table take 15%-30% of cost.
Please help to to resole this issue. I can send execution plan if anyone interested.
Hi, we have a merge pull replication in SQL Server 2008 R2 (publisher) and SQL Express 2008 (subscribers)
The publication contains almost 200 articles.
We are having trouble in only one article.
When we update / insert a row in that table, all the subscribers fail to sync with the following error:
The merge process could not retrieve column information for table 'dbo.Tipo_Movimiento_Caja'. Verify that you have sufficient privileges on the database and retry the operation. (Source: MSSQL_REPL, Error number:
Cannot synchronize the subscription because the schemas of the article at the Publisher and the Subscriber do not match. It is likely that pending schema changes have not yet been propagated to the Subscriber.
Run the Merge Agent again to propagate the changes and synchronize the data. (Source: MSSQLServer, Error number: 25007)
The script of that article is really simple, and it has no join filters:
exec sp_addmergearticle @publication = N'IPoint_Pub', @article = N'Tipo_Movimiento_Caja', @source_owner = N'dbo', @source_object = N'Tipo_Movimi
I added a table to an existing publication and then generated a new shapshot. The merge agents then sent the new table and data down to the sunscribers as planned. The issue is that at the next cycle the merge agent re-initilizes the table again.
This happens over and over again. If I stop and restart the agent I can watch it send the schema back down to the subscriber. Any thoughts are appreciated.
previous post, Hilary replied that the size of MSmerge_Contents doesn't really matter, but index fragmentation does. However, referring to
BOL, it says, "Additionally, you should minimize the size of the merge system tables (specifically MSmerge_history) by using
sp_mergecleanupmetadata." Is it still necessary to do that in SQL Server 2005?
Also, when running select metadatacleanuptime
from sysmergesubscriptions, I found that the cleanup time is just about a week before. However, my merge interval is only 5 minutes, and I remembered during last week I did a manual sp_mergemetadataretentioncleanup although
paused in half way. How to check the clean up interval?
Last but not least, I have already did index rebuild on MSmerge_Contents, MSmerge_henhistory, and MSmerge_tombstone, and found that the average fragmentation dropped from above 90% (MSmerge_Contents) to below 1%, but the overall performance did not improve
obviously. I remembered when merge replication was set up at the begining, th
What is the best method in jQuery to add an additional row to a table as the row below a particular row?