I am replicating (transactional and snapshot) a production DB to a reporting DB. I have then a job that runs that processes the data in the reporting DB in order to produce some custom reports. Does replication have a way so that once the replication is done it will start a job on the reportin...more >>

Hi I was thinking of using sp_browsereplcmds to recover some of the lost data. Im not quite sure i understand this correctly and need some help. I ran select transaction_timestamp from MSreplication_subscriptions on the subscriber to get the last transfer date. In between, a row was updated...more >>

Hi all, I have a merge replication with the publisher SQL Server 2005 and the subscribers SQL Mobile clients.On the server side, I need to execute a stored procedure so as to export data when a subscriber synchronization is successfully completed. I want to know if there is a way to handle a ...more >>

Is there a way to know if the replication is successfu? How would I know that the data in the subscriber is same as the publisher?...more >>

Replicating a huge database with some tables having over 500,000 rows. The databases are in the same domain but the synchronization into this one biggest table over 600,000 rows keeps failing. Any suggestions on how to boost the performance. What settings on the Distributor or Subscriber need...more >>

Hi, I am contacting you all for your help in solving a problem with transactional replication in SQL server 2005. The setup is as follows: One publisher and three subscribers - all are SQL 2005 Distributor database is in the same server as the publisher database. I had set it up and it...more >>

Is it possible to replicate from a SQL Server to a file ? I would like to set up trans replication from a table to a file ...more >>

Running Win 2003 & SQL 2005 on both machines. I created a publication on serverA. I subscribed to it on serverB. I received the error.... Command attempted: E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\REPLDATA\unc\unc\R99S-SQLA_DBMOTO_AS400 MASTER FILES\20061206113840\APVENDP_2.sch...more >>

Hi, I have a SQL Server 2000 database with a merge publication and several subscribers. The publication contains many replicated tables and views, and I want to update a single view. I've been told that this will require me to create a new snapshot and reinitialize all subscriptions, which...more >>

All, In Transactional Pull model, is there a way from any storedprocedure to get notification from the distribution agent that the initial snapshot has been applied on the subscriber? This notification has to be got in my Windows forms C# application and related UI changes done. Can anyo...more >>

We would like to replicate from SQL 2000/2005 Enterprise Edition to its Express version and wanted to know if there we any issues around it. This would be transactional replication ...more >>

....when only the underlying table is replicated? What about when it is inserted using a Stored Procedure? I set up replication on 80+ locations, and left out the views and procs for ease of development...and now I'm having a "gotcha" moment. Thanks! -Joseph ...more >>

Does anyone have experiences in setting up multiple replicated databases using peer to peer replication at the same time? I've been attempting to do so using the GUI and scripting where possible and it seems they always end in deadlocking of resources. I'm testing this possibility for the ob...more >>

I have a view that returns data of some join condition on couple of tables with a filter clause and wanted to know if I could replicate the data as reflected underlying the view ? Thanks ...more >>

Hello, I would like to be able to generate a conflict for merge replication inside a trigger. The problem appears in some tables like 'Customers' where the primary key is an IDENTITY where in the replication is automatically managed by SQL Server 2000 without any problem. But the applica...more >>

Hello, I've actually a configuration with a SQL server 2000 server. data have very small modification in the day. There is only a batch which made more major modification on somes table each night. We want install another SQL server (we need choose between sql2000 and sql2005), which will...more >>

I am getting an error on the Starting Agent area in the merge agent. I know about putting logging on the second step (run agent and put -Output etc), but the Starting Agent is running: sp_MSadd_merge_history @perfmon_increment = 0, @agent_id = 1, @runstatus = 1, @comments = 'Starting agent.' ...more >>

The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. any idea to stop replication not to marked inactive? Cheers, soonyu...more >>

At times, we have come across issues around replication such as high CPU for transactional replication in SQL 2000 that requires a reboot to fix it. Do we know why a reboot fixes ? Right now, we just reboot the server, but dont know how it resolves and what it resolves under the hood ? We ...more >>

trying to add an article to an existing pub w/ subscribers. Executed sp_addarticle ok, trying call sp_addsubscription like in 2000, and am now getting an error: exec sp_addsubscription @publication = 'MyDB_Pub' , @article = 'MyNewTable' , @subscriber = 'SUBSCRSVR' , @destinat...more >>

We would like to replicate from SQL 2005 to SQL 2000 for certain application that are incompatible on SQL 2005. Any issues around it that you may have encountered and would like to share ? ...more >>

SQL2005 - Publisher/Distributor same box - 8way / 12Gb RAM Just upgraded to SQL2005 - have 7 tables in merge w/ > 5mill rows each. Their are many conflicts, about 10000 per hour. Rows inserted at subscriber, pk violation when uploaded to publisher (other processes moving rows). I know, we...more >>