| Thread | Last Post | Replies |
|
| Cross Database Replication | 23 Aug 2008 17:51 GMT | 1 |
Is it possible to setup a table in one database to replicate to table in another database on the same machine?
|
| SQL 2000 merge | 20 Aug 2008 14:32 GMT | 2 |
A customer has a publisher/distributor and one subscriber. Both servers are SQL 2000. This morning, the publisher displayed a message that the snapshot needed to be recreated becuase it was out of date. THe person there answered
|
| sp_addmergearticle Error | 19 Aug 2008 15:17 GMT | 2 |
exec sp_addmergearticle throwing the following error: Msg 208, Level 16, State 1, Procedure sp_addmergearticle, Line 1225 Invalid object name 'sysarticleupdates'. I have looked at the code for sp_addmergearticle procedure and it is
|
| Measure latency using RMO in C# | 19 Aug 2008 13:24 GMT | 3 |
I'm trying to get the latency for a Transactional replication using the RMO interface in C#. I tried to follow the guideline reference in MSDN (http://msdn.microsoft.com/en-us/library/ms146951.aspx) but I got an
|
| Replication Monitor: Online Options | 18 Aug 2008 19:10 GMT | 2 |
Is there any way of allowing users to check their [merge] replication status w/o installing Management Studio? I have MSDE installed on laptops and I would ike my laptop users to be able to check to see if their subscription has been running. (Sometimes the
|
| How to Run Snapshot Agent in Query Analyzer | 18 Aug 2008 06:34 GMT | 2 |
my transactional snapshot agent is failing with "Server Execution Failed" and "No Response in the last 10 minutes" I read in another post that I should try to run the Snapshot agent in Query Analyzer so I can get a more useful output. It sounds like great idea, but I don't know ...
|
| Real time transaction / replication | 17 Aug 2008 17:28 GMT | 2 |
I need to implement a solution for a company with 2 different locations. One is in Hong Kong and another one is in China. They always need to query the data as fast as possible. So I am thinking placing the same database in both locations. Both databases can be query and updated. ...
|
| Changing an article from download-only to bi-directional | 16 Aug 2008 18:12 GMT | 2 |
I have a merge replication set up and I need to change one of the articles from download only to bi-directional. I tried doing this through SSMS and marked subscriptions for reinitialisation and recreated the snapshot. However, when I tried to synchronise I got
|
| repl pending xacts on performance monitor | 16 Aug 2008 16:54 GMT | 1 |
I looked at the performance monitor for Repl. Pending Xacts and there is over 4billion transactions - there is NO WAY that there are that many that need to be replicated, espeically since the other subscriber only gets about 10,000 transactions per day.
|
| Replication problem and MSmerge_tombstone problems | 16 Aug 2008 16:43 GMT | 1 |
We currently have SQL Server 2000 and have merge replication. We have the following process 1. Data is transfered to a laptop, data on the laptop is changed and the data on the server is 'locked'
|
| installing latest SQL 2005 service packs tonight | 16 Aug 2008 16:39 GMT | 1 |
i am going to install the latest sql 2005 service packs on 3 servers that are using merge replication (they are one 9.0.1399 and i know there are SP's after that). Is there anything i need to do differently on those servers since they are using merge replication than i have to do
|
| Oracle DB to MS Sql Server DB Replication question...with views? | 16 Aug 2008 16:39 GMT | 1 |
I'm not sure if this is even possible, but I've been asked to look into replication from Oracle to Sql Server. He's the situation: We have access to a remote Oracle database, but only read access (not allowed to configure or change the db).
|
| Transaction Replication from SQL 2005 / 2008 to MySQL | 16 Aug 2008 16:20 GMT | 1 |
I've been investigating the possible way of getting transactional replication from SQL 2005 or now SQL 2008 to MySQL working, and have not been able to do this. In SQL 2000 I was able to get this up and runnign but there was a documented problem when the distribution
|
| replication monitor not correct | 16 Aug 2008 16:14 GMT | 1 |
Merge replication w/ 2005. I have updated the distributor and 2 subscribers to SQL 2005 SP2 - the update on the subscribers failed for only Analysis Services - all other updates were fine.
|
| backup/restore help | 16 Aug 2008 16:11 GMT | 1 |
i am having issues w/ merge with one publisher and 2 subscribers. the subscribers are not replicating and i can't seem to figure out why. the servers are sql 2005 sp2 for everything except the analysis services. So, i am thinking about removing sql and then re-installing.
|