Hello everyone, I've a problem regarding the merge replication process when using the column level tracking, on either SQL Server 2000 or 2005 (the behaviour is exactly the same). I don't know exactly what I'm doing wrong here. I created a publication (Server A) on single article with colum...more >>

Hello. I have a merge replication scheme, where the synchronization request = makes the clients. I need that when finishing the synchronization, in = the publisher executes a procedure. Somebody knows since I can do this? Thanks Miguel...more >>

I am scratching my head on the documentation. Does it make sense to have either the primary or secondary sever in STANDBY? If so, how to do that? how to verify status is STANDBY? Thanks....more >>

SQL 2005 Can one transactional replication publication be sent to multiple distributors - not direct to multiple subscribers? Basically we are not allowed to place a local distributor on the source database server. We are looking for ways to utilize have multiple publications on the same sou...more >>

We are running a three publication on our head office server (SQL Server 2000) with four subscriber at different location. We just bought a new server and want to replace the old server with new one. Is there is any way that I can move the publication from the old server to new server with...more >>

Hello Everyone This is cross posted in MSDN Forums.... SQL 2005 SP2 Dev/Ed, 32-bit. Transactional replication, R/O, with no filters of any kind. in Log Reader Agent profiles I can not find MaxCmdsInTran parameter listed anywhere in SQL ManStudio UI. What am I missing? I look under di...more >>

Hi, We are thinking of using SQL 2005 Merge Replication. Some of our tables can possibly have larger rowsize as they have NTEXT columns which will be populated with a lot of data. How do we get around the limitation? Does Repliation completely fail in such a situation? Is there a way to le...more >>

hi all, i got below error when trying to configure distributor on my mssql 2000 server. error 14113: could not execute "c:\...\osql" -E -I60 -t60 -d"distribution" -b -i "c:\..\instdist.sql" -o "c:\..\instdist.out". Check 'instdist.out' in the install directory. any ideas on what is c...more >>

We plan to have two stand-alone servers (primary and failover) run MSSQL2000. We want to use replication to keep the failover server up-to-date. When something happens to the primary server, we switch the connections on the application server to point to the failover server. The users shoul...more >>

Hi all, I got error from the merge replication when I tried to synchronization article with blob data (varbinary(max)). The error said, The merge process could not replicate one or more INSERT statements to the 'Subscriber', A stored procedure failed to execute. I tried to use profiler, but...more >>

I am getting Msg 8115, Level 16, State 1, Procedure sp_replmonitorrefreshagentdata, Line 327 Arithmetic overflow error converting numeric to data type numeric. Upon debugging the problem I came across sys.fn_replgetpublicationthreshold. The reason why I am looking at this is because it us...more >>

Good Day, I am using SQL server 2005 with transactional replication to another server. I have a third server acting as the distributor. I would like to shut down the distributor server to install a hard drive but am unsure on what this will do to the replication. If I shut down the server w...more >>

Now I have this errors: * The schema script '\\CBA01\ReplData\unc\CBA01_gcg2_gcg2\20070914120826\DetOrden_587.dri' could not be propagated to the subscriber. * ALTER TABLE statement conflicted with TABLE FOREIGN KEY constraint 'FK_DetOrden_Ordenes'. The conflict occurred in database 'gcg2'...more >>

Hi I have now learned how to create a merge replication and manage a distributor, a publisher and a subscriber. All successful. Great. However, I tried it only on a small test database, and now I would like to bring back the databases on the 2 servers back to completely normal situation. ...more >>