SQL2000 sp4 pub, sql2k sp4 distr, sql2k sp4 subscriber (across wan - t1 tunnel) Transactional replication. Blocking occuring on subscriber causing distr agent to fail 2 to 3 times daily. Distribution server only process connecting to subscriber, blocking & blocked spid numbers differen...more >>

Dudes, I have this customer who is interested to replicate a SQL Server 2005 database to a MySQL database, online... For example, you insert a record to the SQL Server and it automatically inserts it on the MySQL database. Both has the same schema. They are on a LAN or VPN. I just need a...more >>

I am sorry to post about this again, but I can't put my finger on what = is wrong. When we upgraded our ERP to a new version, I am almost certain that I = setup Transactional Replication the exact same way..... I did the following to drop an article from a publication: sp_dropsubscription=2...more >>

I restored a backup from our main server to a new server. First I copied that backup file, then executed a script basically Restore with move, replace (I replaced an empty database I created to test the connection). It ran for a minute or two, then said successful, but here it is 2 hours l...more >>

I am starting this thread in hopes that someone has seen this same problem. I have transactional replication set up in many of my servers but in 2005 I have a big issue when the Distributor is applying the initial snapshot. Because MS decided to implement the "nice" concurrent snapshot I get ...more >>

When adding a column to a table involved in merge replication through stored procedure sp_repladdcolumn: sp_repladdcolumn @source_object = ' InspectorForaneó, @column = ' password', @typetext = ' varchar(20) null' I received the following warning: Cannot add rows to sysdepends for ...more >>

I have a transactional updatable subscriber database that works fine for all articles (164 of them) apart from one where I continuously get the error above. The thing is, msrepl_tran_version is the same on both the publisher and the subscriber. I have tried everything. I've rebuilt the Subs...more >>

I have gone through the steps of configuring morring with SQL 2005 (latest patch is installed) and when I click "start mirroring" I get a 1418 error message. I have also gone through the steps of creating/configuring my end points and granting permissions to these end points using T-SQL. Whe...more >>

hi all, my question is that i want to replicate some tables to another server using transactional publication with updatable subscribers. but i only want some of those published objects to be updatable like i'll send 3 tables of which only 1 of them should be reflected back to the publisher i.e ...more >>

Hy, i have the following problem: i try to modifie an article (table) in a context of transactional replication with queue updating in two way: 1- first way with sp_repladdcolumn and sp_repldropcolumn: add a temporary field to the article: exec sp_repladdcolumn @source_object='Alc_Allarm...more >>

Hi to everyone, our transaction log (again) has reached an unbelievable size (about 4,6 Gb, the corresponding database has about 200 Mb). We do a backup every night (full recovery model). Our system: SQL Server 2000 SP4 (publisher and distributor identical, the publisher itself has no subscrip...more >>

I setup merge replication yesterday on Client A and was successful. Today I changed the gateway and DNS info.; re-ran merge agent and got this error. Error messages: The merge process could not connect to the Publisher 'XXUSSHU18UT:Process'. Check to ensure that the server is running. (Source...more >>

I setup merge replication yesterday on Client A and was successful. Today I changed the gateway and DNS info.; re-ran merge agent and got this error. Error messages: The merge process could not connect to the Publisher 'XXUSSHU18UT:Process'. Check to ensure that the server is running. (Source...more >>

What does this mean? It appears to be keeping the wizard from running the distributor setup on the server. Code used is: use master go sp_adddistributor @distributor = @@servername GO sp_adddistributiondb @database='distribution' GO Error is: Server: Msg 14113, Level 16, State 1, Proc...more >>

Hello everyone, I am having a problem with transaction logs on my subscriber server in a snapshot/transactional replication environment. My publisher (server A) has six (6) databases available for subscription. My subscriber (server B) pulls it's subscription from server A for reporting pur...more >>

Greetings Appologies in advance as this is a bit of a newbie question as I have just started playing with 2005 replication. I am getting the error Column name or number of supplied values does not match table definition. I began ok by setting up replication between 2 servers on the same ...more >>

How do I alter the column of the replicated table ? ...more >>

Hi, We are planning for a global replication in GIS environment that can have up to 1200 subscribers. Actually each subscriber is a station that monitors for example a particular river. There are equipments connected to the river. They measure some chemical characteristics of water and send o...more >>

Hello, I've got a question dealing with automatic identity range management. Currently we have a database setup for publication in which the subscribers are running SQL Server CE on mobile devices. We've got automatic identity range management turned on for a few of our tables and we're hav...more >>

Is anyone aware of a step-by-step video or webcast I can review for setup of Merge Replication? I have setup a Publication on one server and Distributor on another server. I am creating snapshots okay; I see the files are in repldata dir on server. I do not understand Subscriber role. I know ...more >>

I have 2 servers running on workgroups; merge replication running SQL Server 2005 on each, snapshot running ok, start merge agent and get this. Error messages: The merge process could not connect to the Publisher 'XXUSSHU18UT:Process'. Check to ensure that the server is running. (Source: MSSQ...more >>

sql2000 sp4 - transactional replication To track latency I add a record at publisher every 1 minute and record the time to arrive at subscriber. I am using the default profile and am seeing latency of up to 7 hours across wan. We have a dedicated T1 connecting distributor to remote subscrib...more >>

Hello all, I am desperatly need help, our setup is a SQL 2005 server, with merge replication. Filtered rows and 120 pocket pcs (subscribers). We need to delete 100000 rows each night, plus minor inserts, and every time each pocketpc gets all deletes which kills me and them. I have searche...more >>

I have a 90million row table I am trying to replicate to a reporting server that keeps sticking at the distribution agent with the dreaded: "the process is running and is waiting for a response from ..." I've tried increasing the QueryTimeout to ridiculously large (19200). I have tried comme...more >>

Hi, I have a database with size 20 GB. The DB contains 550 tables, 2110 stored procedures. I need to write this DB in a DVD. So I have to reduce the DB size around 6 GB. It is not necessary that all the data should be in DB. Some sample data is enough. Is there any way to do it with le...more >>

We need to replicate a source db with multiple target db's. The program "owning" the db's dont like the extra columns being added when you setup replication (At least the way I do it) Is there a way to set up replication without thoes columns?? Svein...more >>