Hi, I need to perform a maintenance batch process on tables that are being replicated on some tablet PC's. Is it possible to lock these tables so that replication is not performed during the batch process. Regards Simon...more >>

Hi, I had to add a new field. Right now the field is empty (no records). However, I want to bring the field in the subscriber. However, while synchronizing I am getting the following error: Setting up to Sync PWO tables from Master to Laptop and vice-versa. Copying selected data both directio...more >>

Hello! We have setup up transactional replication with dedicated distributor in SQL Server 2005 environment. I have noticed that during particular time of the day latency is increasing dramatically. I have been checking Tracer Tokens and Total latency during that time is around 30-40...more >>

Hi, Is there a way to not include a foreign key column in merge replicaiton. it is possible in transactional replication but not possible in merge. for example Table1 col1 pk Table2 col1 pk col2 fk on Table1(col1) i do not want to add col2 of Table2 for merge replication Any point...more >>

I installed IIS and the SQLServer Mobile server components. I'm getting an error when i Finish adding the Subscription - it's regarding the URL name on "Web Server Authentication" screen. The error is: IIS Error 405 HTTP_STATUS_BAD_METHOD: The HTTP verb used is not allowed. HRESULT 0x800040...more >>

SQL2000 trans repl - seperate dedicated distributor. Posted question prior about a failed subscriber. Server crashed, completely lost. We were able to drop subscriptions at pub, but distribution agent was not deleted. Just stuck in a red-x - "...subscription has expired "... err msg. Per...more >>

We have an imaging product that is running on a Win2K SP4 server utilizing SQL Server 2000 Standard Edition for it's database. We are preparing to upgrade the imaging product but there is a history of bad upgrades. So, I need to create a copy of the production server to a new server and test...more >>

Hey everyone, I have geographically distributed databases where I am replicating some tables between SQL 2005 instances via a transactional push replication. Because of the size of the DB and some network speed issues, running a snapshot is not possible as it causes downtime. I am 100...more >>

We have a new merge subscriber (SQL 2k SP3, same as publisher) that has drastically different rowcounts after completing synchronization. The first attempt was the standard "Add New Push Subscription", but after completion, the database was not complete. It was missing rows in most of the ta...more >>

I do have a problem in executing parts of the script generated by the "script generator" on a replication job. I have a merge replication "pull subscription", and a job that replicate. This works perfectly However, I do want to make the script that creates the job, and the script can be gener...more >>

Hi I found an article: http://msdn2.microsoft.com/en-us/library/ms151169.aspx which could explain the detailed steps on a replication on demand which I seek desperately a solution on It.s a Merge replication - a push subscription, and must be done from the subscribers. Unfortunately, ...more >>

Hello Sorry i don=B4t know english very well. I work with: Windows 2000 Server SQL Server 2000 SP4 Replication Transactional with queue update Queue Reader error: DISTRIBUIDOR.Comercial: {? =3D call dbo.sp_getqueuedarticlesynctraninfo (N'COMPLETA', 120)} Servidor: DISTRIBUIDOR, ...more >>

I have a table on sql2k under replication as below (it is a huge job to change schema you know that). the table has 500K+ rows. now I need to add one column using script exec sp_repladdcolumn 'TheTable', 'AllowRebuy', 'tinyint NULL', 'all' and the script took 5+ minutes to run; ca...more >>

I am trying to figure out how to move replication off our cluster and onto a separate distributor. But, what happens if the distributor itself goes down - is there any way to recover from that? Looking at http://support.microsoft.com/kb/886839, you should be able to restore the database. I al...more >>

Is it possible to replicate encrypted data from SQL Server 2005 to Oracle? If so how would this be accomplished? I have seen articles on what it takes to do SQL Server to SQL Server, but not SQL Server to another RDBMS. Thanks ...more >>

hi, Currently, I did a merge replication for BLOB. if the blob column size less than 495MB, the synchronization is ok. if size more than 495MB, the synchronization will be failure. Does anyone has this kind problem in merge replication? The detail information of my merge replication are: ...more >>

Hi, I'm setting up Transactional Replication betweeen SQL 2K and SQL 2K5. This includes tables, SPs for replication. One of the tables is associated with a trigger that invokes a strored procedure. And when I initiate the Replication process, the table and SP is replicated but not the ...more >>

Hi All! I need one help. I have Push Transactional replication on SQl Server 2000. Currently Publisher and Distribution database both are on OLTP Prod Server. Now I want to Move Distribution database from publisher to other remote server without breaking the replication setting. Just helpme. ...more >>

Hi, We are replicating a table with an int identity column and getting the following error. Can anybody suggest a workaround? It is straight transactional replication with no subscriber updates. Date 12/10/2007 1:13:21 PM Log Job History (SFVTDB4001-oslpclnt-Pub_oslpclnt-SFVRDB4001-12...more >>

Hi all. Any assistnace regarding this would be greatly appreciated. We currently have the following setup (all SQL Server 2005 Standard SP2) Datase Server 1 (Primary Database configured with local distributor) Database Server 2 (Secondary Server) Subscriber1 Subscriber2 My question is :- ...more >>

Hi.... We have setup database replication and we're now finding the transaction log growing very quickly. The publisher is about 15GB and the log file on the subscriber has filled up the disk at 15GB. This happened when the subscription was reinitialized. Any thoughts? Thanks for you ...more >>

We are currently running SQL 2000. But we have SA so we are thinking of upgrading to SQL 2005. The main reason for us possibly upgrading is for implementing Database Mirroring. I need a little help with determining what would be the best option to implement and use. If we stick with SQL 20...more >>

One of my subscriptions recently stopped replicating. When I went to view the subcription agent it pops up with this message: "The specified pull subscription is not configured with a synchronization agent job. (.Net SqlClient Data Provider)." Previously the sub was working and if I execute ...more >>

Hi, I've been trying to set up notifications on the transactional replication latency alerts but it didn't work as smoothly as I hoped it to. I got transactional replication with remote distributor and a single subscriber - all are SQL Server 2005 SP1. Both the log reader and the distribut...more >>

All servers SQL2005, transactional replication, dedicated distributer. I'm trying to avoid reinitializing the entire subscription (and recopying all the data for the articles that didn't change). Is there way to do it without creating a separate publication for the new articles? Thanks, ...more >>

Hi - I have a transactional replication setup in SQL2K5(Enterprise edition). Currently not all the tables are replicated. The tables which are replicated currently have size about 80 Gig. Now I want to add another table into existing replication. I am adding this table using replication GUI. ...more >>