Add article to merge publication cause, again applied to the subscribers every time the merge agent runs Hi Ed, unfortunately no. I've tried to run sp_enumeratependingschemachanges to run sp_markpendingschemachange later - as Paul suggested. However, although sp_enumeratependingschemachanges does not show any pending changes, the schema changes are again and again applied. Tom U�ytkownik "ed" napisa� w wiadomo�... 7 Oct 2009 16:24
SQL Replication Presentation.... I am looking for a SQL 2005 Replication Presentation that can be sent to an IT Team. It does not have to be a step by step guide to setting up replication, but one that explains the concepts & best practices of replication. Does anyone out there have one or knows where I can find one?? AHIA, Larry.... ... 12 Oct 2009 11:48
Merge w/ NoSync deprecated So this article says to not use it, will be removed in future version http://msdn.microsoft.com/en-us/library/ms152488.aspx How the heck am I doing to push a 20Gb snapshot over a 3Mbs WAN conn Calif to Europe? Currently it takes 17+ hours, and given the amount of changes in our environment that is way too mu... 2 Oct 2009 09:46
How to run a snapshot when one or more tables belong to other This post was solved by our technical team. We found out that the error was caused because the Merge System Tables of the suscriptors were corrupted. For some reason that we do not know there was the information of previous replications in the table. So when the replication occurred all that information was bro... 16 Sep 2009 19:45
MSSQL_REPL22037 error while doing replication Hi there, I need some help. I'm replicating from an Oracle server to MS SQL 2005 server using push transaction replication. If i add a new record in Oracle, it works. But when i tried to update or delete the record in Oracle, it gives me the above error. the detail of the error is as follows: "ORA-01008: no... 15 Sep 2009 05:43
638233 M3i Zero , Ezflash Dsi , R4i Dsi 00940 Consigue tu M3i Zero , Ezflash Dsi , R4i Dsi M3i Zero www.R4spain.com/tienda Puedes comprar M3i Zero , Ezflash Dsi , R4i Dsi GxYv#g=uH*^If=r?VMoB(a)eONK ... 8 Sep 2009 10:18
Dynamic filter with GETDATE() Thanks, finally we solved the problem with a special row where we set a mark when row becomes obsolete. This mark is updated every day with a scheduled job. Roman ... 3 Sep 2009 07:51
Replicaiton failing ok gurus here is an interseting situation we have a replicarted sql server that is failing due to the sp called sp_deleteolddummyforreplicate where is this sp what are the parm it is lloking for the message says it is missing 2 parms?? thanx much Wisord *** Sent via Developersdex http://www.developersdex.... 3 Sep 2009 07:51
error "Unexpected EOF encountered in BCP data-file" when initializ Susan, I've got the exect same situation. How did you resolve it? ... 3 Sep 2009 07:51
Loose all data from tables I have created a database in a SQL server 2005 Workgroup edition and setup merge replication to several remote PC's. The server is the publisher and runs the merge agent All the subscriptions are of Client type The remote PC use a VPN to connect to the server. All the remote PC's are Windows XP running SQLExpres... 25 Sep 2009 16:26 |