Archived Months
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server replication > recent posts

RE: Show pending merge changes
Posted by Raju at 4/10/2008 12:14:43 AM
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 >>

RE: The process could not bulk copy out of table '[dbo].[syncobj_
Posted by Stefan at 3/12/2008 4:28:35 AM
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 >>

RE: syncobj_* views?
Posted by Bianca at 12/4/2007 8:02:00 PM
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 >>

Problems with SQL 2005 Merge Replication and blob, nvarchar(max), nchar(max), image objects .waiting for 10 mintues
Posted by SafetyMan from Louisiana at 11/30/2007 4:02:51 PM
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 >>

Re: aut-restart
Posted by Hilary Cotter at 11/3/2007 9:08:04 AM
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 >>

Re: Replication From 2005 to 7.0
Posted by Hilary Cotter at 11/3/2007 9:06:40 AM
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 >>

Re: Transactional Replication Distribution agent
Posted by Hilary Cotter at 11/3/2007 9:05:34 AM
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 >>

Re: Some tables not getting updated under merge replication
Posted by Hilary Cotter at 11/3/2007 8:59:02 AM
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 >>



RE: Running ACT! 2008 Database on two Laptops
Posted by John Bell at 11/3/2007 8:13:01 AM
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 >>

Running ACT! 2008 Database on two Laptops
Posted by Charles Turner at 11/3/2007 12:00:00 AM
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 >>

sincronizing an out of date backup
Posted by Lina Manjarres at 11/2/2007 8:28:00 PM
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 >>

Re: invalud column name error in merge replication
Posted by Darin at 11/2/2007 3:05:48 PM
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 >>

aut-restart
Posted by Darin at 11/2/2007 3:03:49 PM
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 >>

Some tables not getting updated under merge replication
Posted by at 11/2/2007 10:53:48 AM
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 >>

Replication From 2005 to 7.0
Posted by pag NO[at]SPAM associateddynamics.com at 11/2/2007 10:42:39 AM
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 >>

Transactional Replication Distribution agent
Posted by Shahid Saleem at 11/2/2007 5:17:48 AM
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 >>

Re: Transactional Replication questions
Posted by gigel at 11/1/2007 4:25:12 PM
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 >>

Re: Transactional Replication questions
Posted by Hilary Cotter at 11/1/2007 2:22:39 PM
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 >>

Re: sp_helpsubscription_properties
Posted by Brian at 11/1/2007 11:51:35 AM
BRILLIANT!!! Thanks ...more >>

Re: sp_helpsubscription_properties
Posted by Brian at 11/1/2007 11:51:14 AM
BRILLIANT!!! Thanks ...more >>

Re: Transactional Replication questions
Posted by Ron at 11/1/2007 8:45:03 AM
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 >>

Re: invalud column name error in merge replication
Posted by Hilary Cotter at 11/1/2007 6:24:01 AM
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 >>

RE: Login failed for user '' in a Transactional Replication
Posted by Mike at 11/1/2007 2:36:00 AM
Hi Fernando, Did you figure this out? I have the same problem. Cheers. Michael...more >>

Re: Remote Distributor: how to set one up?
Posted by bourgon NO[at]SPAM gmail.com at 11/1/2007 12:00:00 AM
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 >>

Re: Invalid Object name 208
Posted by Pete Vickers [MVP] at 11/1/2007 12:00:00 AM
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 >>

Re: invalud column name error in merge replication
Posted by Darin at 10/31/2007 11:16:52 PM
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 >>

Re: Replication Wizard - Connectivity Issues?
Posted by Hilary Cotter at 10/31/2007 10:43:40 PM
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 >>

Re: How to create a suscription?
Posted by Hilary Cotter at 10/31/2007 10:41:27 PM
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 >>

invalud column name error in merge replication
Posted by Darin at 10/31/2007 10:34:54 PM
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 >>

Re: SQL 2005 Merge w/ different domains
Posted by Hilary Cotter at 10/31/2007 10:34:13 PM
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 >>


DevelopmentNow Blog