This stored procedure does not work, if the merge agent has started and failed to synchronize (may be due to a network issue). From http://www.developmentnow.com/g/114_2006_5_0_0_762643/Show-pending-merge-changes.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I just got exactly the same problem here. did (in the meantime) anyone find a solution for the problem? From http://www.developmentnow.com/g/114_2004_9_0_0_446119/The-process-could-not-bulk-copy-out-of-table-dbo-syncobj-.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Hello, i was searching information about the syncobj* views. Do they always need to be under the public role? or can we assign these views to specific users and roles. Thank you very much. From http://www.developmentnow.com/g/114_2004_1_0_0_443938/syncobj-views.htm Posted via DevelopmentNow.com...more >>

SUMMARY: I have a table which is about 11GB in size, This table contains 3 fields. One of the fields contains a ntext() data type. The total number of records is about 400,000. This table replicates fine when it is over a very fast gigabit(Gb) network or even a 10/100 link(100 mbs). But once I ...more >>

I schedule the agent to run every 5 minutes. If this does not work for you, you can have a 4 job step so if job step 3 fails job step 4 will run. It will have a waitfor delay for 5 minutes and then loop back to job step 1. -- RelevantNoise.com - dedicated to mining blogs for business intell...more >>

In SSMS (SQL Server 2005 Enterprise Manager) register your SQL 7 server. You should be able to create your subscription now. -- RelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking ...more >>

There is a parameter on sp_update_jobstep called retry_attempts. You can also find it by right clicking on the distribution agent, and selecting agent properties, steps, and double clicking on the run agent step, click on advanced and you will find them there. -- RelevantNoise.com - dedic...more >>

These tables should be getting updated. Check the conflict viewer to see if there are any conflicts there. -- RelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on I...more >>

Hi Charles You don't say how you have restored the database on the second machine? My guess is that the login you have created on the restoring machine is either not present has been orphaned, and that is why you can not connect. You could use SQL Profiler on the machine that works to see h...more >>

Hi guys, Hope some of you SQL database experts out there can help me, 'cos at the moment I'm going mad! I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is my own (Vista) and the other is a company laptop. I can't synchronse using a network connection between the two...more >>

Hi people!! I have a question. If I have a remote database sincronizing with a server, and doing backup every night. Let's imagine the remote machine gets broken. May I take the backup to start sincronizing it. Will I loos some data? Thanks for your help!! Lina...more >>

I had and i couldn't find the table name that was causing the error. Luckily i had only added 4 tables to the replication and i knew the 4 and so i only had to look at those few. Darin *** Sent via Developersdex http://www.developersdex.com ***...more >>

Windows 2003 w/ SQL Server 2000 merge replication Is there a way to have the synchrnoziation process restart after a set amount of time when an error occurs - such as general network failure or deadlock error? Darin *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, Under merge replication I have setup a few filters for some of the tables and for the rest of the tables no filters have been created. Now what I noticed is some of the tables for whom no filter had been created are not getting updated but the ones with filters associated to them are be...more >>

Hi, I am looking to set up transactional or snapshot replication from 2005 to 7.0, but I am struggling as this does not seem to be well documented, and Enterprise Manager doesn't seem to be able to see 2005. I have a publication set up in 2005 - what do I do next with 7.0? Thanks in advanc...more >>

Dear USers I have configured a transaction replication and distribution agent is set to run automatically , Occeasionly network connection is not available , can you please tell me from where i can set retry intervals for distribution agent , and if distribution agents fails to connect to sub...more >>

Will this sub-sequent run of the snapshot publish only new articles or will take a brand new snapshot of the entire database? Couldn't tell from BOL. Gigel "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:O6jchRLHIHA.4476@TK2MSFTNGP06.phx.gbl... > there is a proc to start ...more >>

there is a proc to start the snapshot. sp_startpublication_snapshot Forgot to mention it. -- RelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Service...more >>

BRILLIANT!!! Thanks ...more >>

BRILLIANT!!! Thanks ...more >>

I tried adding a new stored procedure to the publishing database and then added it to the articles to be published. It never went over to the subscription database. When/how does the snapshot get automatically generated and distributed for this new article? Thanks. "Hilary Cotter" wr...more >>

Next time enable logging to find out which one. http://support.microsoft.com/kb/312292 -- RelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL ...more >>

Hi Fernando, Did you figure this out? I have the same problem. Cheers. Michael...more >>

On Oct 31, 6:27 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote: > Have a look at this: > > http://www.nwsu.com/lowres_replication_ch02.pdf Doh! /Pulls book off shelf. It helps if I actually _read_ the book, I guess. Thanks, Hilary. ...more >>

Hi, thanks - will give it a try when I go back to site "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:OQJ6NwBHIHA.5544@TK2MSFTNGP02.phx.gbl... > do an sp_droparticle 'PublicationName','sp_recreate_cybertill_tables' in > the publication database > > -- > RelevantNoise....more >>

I have figured out the issue. One new table didn't have a rowguid column. What is iratating is that SQL didn't tell me which one. It would have been nice if the error had said the table name. Oh well - live and learn. Darin *** Sent via Developersdex http://www.developersdex.com ***...more >>

On the publisher do this select @@servername and compare what is returned from the hostname (at a command prompt type hostname). If the root (ie the non instance part) is the same you should be able to create the publication. -- RelevantNoise.com - dedicated to mining blogs for business...more >>

They need to be able to connect to server A. create an alias to it using Client Network Utility (SQL 2000) or SQL Configuration Manger (SQL 2005). Then try to register the Publisher (Server A) in SQL Server Management Studio, once this is done the subscriber will be able to see the publisher....more >>

i have done merge replication on this machine many times. This time (like other tiems) i completely removed and disabled replication on the publisher/distributor using EM, and deleted replication on the subscriber using sp_removedbreplication. I recreated replication and when i do the push new...more >>

Its for the publisher. When you set up the subscriber there is a dialog which allows you to specify the publisher and subscriber accounts and passwords. -- RelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu...more >>