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 >>

I currently have replication running on SQL Server 2005, SP2. I want to use a remote distributor. Is there any feasible way to move my publications to use this new distributor, or instructions on doing so? Or do I set up the distributor, then recreate replications, telling them to use that on...more >>

I've been playing with replication for the first time today, and I almost got it all to work...except I'm running into what must be common problems: 1) Let's say I have three views, named: vw_view1 vw_view2 vw_view3 Let's say vw_view1 references view2, i.e., SELECT * FROM view2 S...more >>

SQL2005 sp1 Once transactional replication is set up and running, Will changing a table's structure (new column or new or changed SP) be carried over to the replicated database? Will it result in a replication failure and cause replication to stop? Does a snapshot automatically run ...more >>

Hello, I'm fairly new to SQL commands so if I'm posting this in the wrong location, please let me know. When I run sp_helpsubscription_properties from a former subscriber, I am receiving two rows of publisher data. How do I delete these entries? I've tried drop_server but that just gets rid...more >>

Hi, when trying to replicate, after adding a new table, then i am getting the error "Invalid object name 'dbo.sp_recreate_cybertill_tables'. (Source: MSSQLServer, Error number: 208)" This stored procedure no longer exists, but I can't get past this error. I have tried a re-initialize, bu...more >>

Hello, We've got a very large production database with transactional replication between two SQl 2000 servers. We would like to set up sequential (cascading) replication between the current subscriber and a 3rd server... running SQL 2005. The problem we have is that it turns out we do not...more >>

Hello all, I am looking into setting up a bi-directional transactional replication environment as a high-availability solution. Is this a practical solution? Could I easily fail-over and fail-back? Manually won't be a problem. I need to be able to pull out the publisher or subscriber for ...more >>

Using SQL2005 SP1 transactional replication to a reporting server. I'd like to be alerted when replicaton stops for whatever reason. Is it best to be notified via Database Mail for specific replication jobs. There seems to 9 replication jobs alone on the publisher/distributor server. Whi...more >>

Publisher: - Windows 2000 SP4 - SQL Server 2005 Subscriber: - Tablet XP SP2 - SQLExpress SP1 - Merge Pull subscriptions with parameterized filters All, As brief as I can: We have 2 table articles and a trigger in our publication. The 2 tables, Table A and Table B, have...more >>

I have 2 SQL 2005 Servers SERVER1 and SERVER2 and want to establish a replication betwwen them: SERVER1 as Publisher and SERVER2 as subscriber. the problem is that SERVER2 is runnint on port 2433 and -I dont know why- I cannot switch it to port 1433. When trying to push a new subscription o...more >>

We here at $SOFTWARE_VENDOR are putting some numbers to various reporting database scenarios, one of which includes log shipping. How long does it take to replay a log on a target database? What are the influencing variables? It will be something like a 100MB log replaying on a $10k dedicated MS...more >>

Using transactionl replication to replicate data to our reporting server. The distributor agent is running on the subscriber. Concerned that if for some reason the distributor agent is down or out of service replication changes to the live data will not be replicated to the reports database....more >>

Hi, I'm adding a new table into a DB which is published already. At present I'm looping through all the tables and finding it whether the table has added for publication, and if not enable it for publishing. But the number of article size is large. So it leads to a performance issue. Is...more >>

I have a publisher/distributor on one domain, and the subscriber is on a different domain. Both use administrator, but have different passwords. There is an SQL security account setup that I can use to access the servers via Server Management studio on both machines (both machines can access bot...more >>

Hello, after fighting to SQL Server replication, I'd like to know how to create a suscriptor on a machine "B" for a publication make on a machine "A". Distributor is placing on the machine "A". The problem is the new suscriptor on the machine "B" cannot view the "A" machine publication. Som...more >>

Hi, I've got two servers to be a subscriber and publisher resp. The server machines are in a secured environ. and I usually use my own laptop with SQL Server 2005 on XP SP2 to connect to these machines either through Man. Studio over TCP/IP or sometimes I connect using mstsc (remote desktop c...more >>

How do I create and sync a local table from a subscription? I imagine I'm missing something simple. I currently have a sales order processing Access/SQL 2005 applicaiton we run on our SBS2003 lan. I'd like to run it disconnected from other locations and sync the changes. Reading trough the ...more >>

HI, Any ercomendations for a good 3rd party S/W for sql 2000 replication using minimum bandwidth over a WAN? Thanks....more >>

Hi We have a Microsoft Access app which uses Access replication to allow laptop users to disconnect from LAN and be able to work offline. The data gets synched between laptop and server Access databases once users are connected back to LAN. We need to port this Access application to sql ...more >>

I have the following scenario: Server A; database = databaseA Server B; database = databaseB Server C; database = subscriberAB Database A and B have the same tables; table name, structure. I need to replicate all changes from databaseA and databaseB to subscriberAB. Question: Can this be d...more >>

I'll give this a shot. We are attempting to setup a master republisher model for horizontal scaling of our mobile devices. We currently have what will be the republisher with CE's connected to it. The goal being I do not want to cause re-inits and data loss from the CE's to the republisher w...more >>

I have replication running from SQL2005 to SQL2000, The amount of data has grown so large that when a new snapshot is generated it takes a very long time to send to the subscriber. I am using push transactional replication. The distributor and publisher are on the same server in Germany and th...more >>

Hi, I'm setting up Transaction Replication b/w SQL Server 2K and SQL Server 2K5. I have published Tables, Views and SPs as articles. One of the views has more than 300 columns. So when i try to replicate it, I'm encountering the following error Message. "Error 20068: The article cann...more >>

Hi, I'm setting up Transaction Replication b/w SQL Server 2K and SQL Server 2K5. I have published Tables, Views and SPs as articles. When I try to modify the published Stored procedure, the changes are not replicated. When I Reinitialize the Subscription and start the Snapshot agent, it is...more >>

I'm facing some problems with the Snapshot Replication with error "StartIndex cannot be less then zero" and unable to find a solution for this. I'm seriously looking at Mirroring instead as an alternative solution. The question is since I'm having 5 databases (one around 60GB) used for HR, ...more >>

Hi! I need to subscribe a server in some publications to synchronize data from my host server (server1) to my back end server (server2) that work in diferent environments. When I subscribe the server2 in a replication it returns the following message: Error messages: Login failed for u...more >>

FIX: The Distribution Agent may skip some rows when you configure a transactional replication that uses the "-SkipErrors" parameter in SQL Server 2005 Can some one please confirm is this applies only to Publisher,Distributor,Subscriber Computers or applies to all. Please confirm. Than...more >>

I lost a whole server (was windows 2000 sp4 with sql server 2000 sp3). Restored from backup on new server hardware (new idently as far as domain goes also, did not bring back old server's identity). Luckily I had a full backup from just the day before. I setup new server (w2k3 r2 sp2) and i...more >>

hi, we are trying to setup replication over a 4m sdsl line. the size of the database is about 8Gb. there are about 150 to 200 tables. we first made a snapshot that went ok, but if we push it over the internet to another server we get a bulk copy error on big tables (>35000 records) it retr...more >>

I am getting this error: The row was not found at the Subscriber when applying the replicated command. I have a transactional replication with row filters with UDFs on some tables and we are replicating data from internal sql server db to web sql server db. We have an internal system that s...more >>

Hi, I am using sql server 2000. In my replication program i need to exclude delete statements. I want to replicate only insert and update statements. Can any one help me......more >>

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 >>