Rating Thread / Thread Starter	Last Post	Replies	Views
Bidirectional Replication Hello, I am trying to perform 2 way replication in SQL 2000. SERVERA = OrdersTable -> I want data to replicate to this server from SERVERB on... niv	05-28-2004 08:21 AM Hilary Cotter	1	67
Cannot find sp_repladdcolumn stored procedure. I have merge replication set up on several database tables. I was reading about using sp_repladdcolumn and sp_repldropcolumn to make modification... Bill Mitchell	05-28-2004 07:39 AM Bill Mitchell	2	65
Log Shipping Copy Job reports successful, but copies nothing I have set up log shipping between 2 servers but cant get it to function correctly. Everything seems to be fine, the backup job happens, dumping... Gregory	05-28-2004 04:42 AM Paul Ibison	3	80
Merg replication: subcriber fail to connect to snapshot data I am new in replication, but really need your help... My replication is simple but I am struggling Set u -Win 2000 server with sql20 - 2 server, non... haith	05-28-2004 03:59 AM Paul Ibison	3	73
Merge Replication Agent Process is blocikgn other users Hi I have Merge replication on SQL 2000 since last 6 months Recently I have notice that process is blocing other users and than timeouts on its own.... Nilay	05-28-2004 03:46 AM Paul Ibison	1	71
Data replication issues Hi, We have an SQL server (lets call it FTANT001) and a datatbase (lets say LETS30). I want to replicate the database in the same server under the... Sabuj	05-27-2004 03:44 PM Paul Ibison	1	73
Not publishing transactions to distribution database That was it... Thanks!!! DB "Hilary Cotter" <hilaryk (AT) att (DOT) net> wrote alien2_51	05-27-2004 02:09 PM alien2_51	1	69
Re: Implementing Log Shipping Stacey, this is quite normal, assuming the (now carbonized) 'Tiger' is no longer part of the same domain. In fact any distributed queries using a 4... Paul Ibison	05-27-2004 11:33 AM Paul Ibison	0	76
Queued Transaction Failing Hello, Can anyone help me with a Queued Transaction thats failing? I just set this up to do a snapshot and queued tranactional rep. The snapshot... Rose	05-27-2004 11:26 AM Paul Ibison	6	70
Replication Stopped Hello! Hope everybody is doing OK. I have a question. I don't know why replication suddlently stopped. In this case how can I check what was the... Marlene A. Roman	05-27-2004 11:03 AM Paul Ibison	3	88
Re: Snapshot remove (try again Hit the enter key to soon) Russ, The easiest way out of your dilemma is to disable the job. BTW for a nosync subscription, running the snapshot agent shouldn't actually do... Paul Ibison	05-27-2004 10:35 AM Rand Boyd [MSFT]	1	78
Schema replication failed Hi! I've got the following error, while trying to change schema on published DB: 21260 16 Schema replication failed because database '%s' on... Alexander Kachalkov	05-27-2004 10:13 AM Paul Ibison	5	81
Move Distribution Hi All I have 1 server as publisher and distributor with SQL 2000 sp3a and I have about 100 subscribers I have to move my distribution database... cb73	05-27-2004 09:46 AM cb73	0	94
El Proceso no pudo entregar la instantanea al suscriptor Hola colegas, tengo un replicación de tipo Mezcla(Merge) con 2 suscriptores de tipo extracción(PULL) en Microsoft Sql Server 7.0 estaba trabajando... Christian Olivera	05-27-2004 09:32 AM Paul Ibison	1	105
Replication error 28037 I am using merge replication between SQL Server 2000 sp3a running on windows 2000 server sp4 and sql server ce 2.0 over gprs. First time when I... Marius Bucur	05-27-2004 06:25 AM Marius Bucur	2	104
Getting rid of deleted subscriptions in EM We have a T-SQL script that enables replication on a server, creates a publication on that server, and pushes a subscription. We also have a script... Stephanie	05-26-2004 03:05 PM Paul Ibison	3	76
Re: Agent History? A session is basically the period between the merge agent starting and stopping. The merge history is logged as one entry per session. So, if you... Reinout Hillmann [MS]	05-26-2004 12:56 PM Reinout Hillmann [MS]	0	68
sp_mergemetadataretentioncleanup We really don't know. First it was undefined, then we made it 10 days, it worked, then to 3 days it worked, then to 7 days it worked, then to 15... goka	05-26-2004 12:41 PM Reinout Hillmann [MS]	6	274
What happened to my PK's???? Sql 2000, Enterprise Edition, Windows 2003 Basically what I did was; 1. Alter tables with identity columns = Not For Replication 2. Changed all... JLS	05-26-2004 11:22 AM JLS	7	92
Re: moving databases with replication Henry, when you backup and restore databases from one server to another, the replication settings won't be preserved (this is potentially different... Paul Ibison	05-26-2004 11:16 AM Paul Ibison	2	79
Cannot drop the table "xyz" as it is being used for replication I have a replication setup running on 2 Win2K Server PCs with SQL Server 2000. Both the PCs have a common DB installed on them. The setup takes care... nelabh	05-26-2004 06:19 AM Paul Ibison	1	93
Could not find stored procedure 'sp_MSins_<table_name>'. Error message for a Distribution Agent: "Could not find stored procedure 'sp_MSins_<table_name>'." elham panahy	05-26-2004 06:07 AM Paul Ibison	1	168
Warm standby FUBAR ( 1 2 ) Dear All I successfully put in place a high availabiilty replication server using Snapshot and Transaction Repliction (thanks to those here who... Peter	05-26-2004 06:00 AM Peter	10	131
merge replication agent error Hello i have problem with merge replication agent. the agent stops with error message "Der Prozess konnte die Ã„nderungen auf 'Subscriber' nicht... ReneHelbig	05-26-2004 05:36 AM Paul Ibison	1	115
15004: Name cannot be NULL Hi, I am trying to create a pull subscription on a server. By the end of New Pull subscription Wize, an error message shows '15004: Name cannot be... Ping	05-26-2004 04:52 AM Paul Ibison	6	104
Merge Replication Conditional Filter with UDF Problem ( 1 2 ) I'm still getting this error in Replication. Does anyone know if its a known issue The error is that when I call my UDF below in my Dynamic Filter... Cube	05-25-2004 02:15 PM Paul Ibison	10	131
Re: Add Article To Trans Rep Joe, have you run the distribution agent? Run sp_browsereplcmds in the distribution database to see if your new rows are waiting there. If they... Paul Ibison	05-25-2004 11:51 AM Paul Ibison	0	95
Error when adding replicated column Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object... Brad M.	05-25-2004 11:12 AM Brad M.	0	83
SQLServer 2k replication setup problems Hi all. This is fairly long but hopefully makes sense... We have a requirement for bi-directional or two way replication on a sql server db, but we... Karl Rhodes	05-25-2004 09:47 AM Karl Rhodes	1	84
delete duplicate records How do I delete duplicate records in a table which doesnot have any identity colum in a single query pls help Manivannan	05-25-2004 03:00 AM Paul Ibison	1	78
sp_repldone Can someone give me an example and basic explanation of sp_repldone. BOL is getting me down ;-) -- Duncan Duncan	05-25-2004 02:55 AM Paul Ibison	1	90
Blocking The process After Replication I am using merge Replication.After Replication is over.My publisher is Blocking the Process and due to which the users are unable to login into the... Asif	05-25-2004 12:16 AM Asif	0	99
Deletes in the subscriber Hi I'm having a problem with replication The situation is the following Operating System of the server: Win server 200 Database: SQL 200 Subscribers:... PPereira	05-24-2004 08:34 PM Reinout Hillmann [MS]	1	70
Violation of primary key constraint I realize this issue has been posted MILLIONS of times, and believe me I have read many of them and find no clear explanation as to the cause or how... dmackto	05-24-2004 08:21 PM Reinout Hillmann [MS]	1	74
Is there a way to replicate the contents of a view to a table (like RDA in SQL CE)? Hello, I'm wondering if there is a way to replicate the contents of a view to a table using SQL Server 2000 and MSDE. Currently we use Remote Data... Eli Tucker	05-24-2004 03:52 PM Paul Ibison	3	74
error 7102 I have merge replication setup on SQL 2000. I am getting the following error during when the snapshot runs: Error: 7102, Severity: 20, State: 7 SQL... Dave	05-24-2004 01:47 PM Dave	2	79
Replcation Stoped Hello! Hope everybody is doing OK. I have a question. I don't know why replication suddlently stopped. In this case how can I check what was the... Marlene A. Roman	05-24-2004 11:29 AM Paul Ibison	1	76
Problems w/Transctional Repl. I am attempting to replicate an accounting database to another database on a seperate server. I get the following error "Error 15006: Invalid... Scott	05-24-2004 10:48 AM Rand Boyd [MSFT]	1	75
Migration Access - Sql Server Hi I am new to Sql Server I have a development done in MS Access, it is running on a server, splitted BE / FE and replications for we have 5 laptops... Pata	05-24-2004 07:23 AM Paul Ibison	1	73
snapshot performance tips Hi everyone, I'm currently running sql2k sp3 on win2k3. It's a clustered server and running merge replication with another clustered server offsite.... leon	05-24-2004 06:36 AM Paul Ibison	3	88
Restoring the replication environment Is it possible to restoring the master db ?? This is to restore the merge agents settings, without creating the merge agents again? If any one got an... Binoy	05-24-2004 02:57 AM Paul Ibison	1	77
Merge Agent Hangs (reporting no errors) Hi, In my merge replication scenario I use Push subscriptions. The distributor is SQL server 2000 Sp3a, and subscribers are MSDE SP3a. Everything... Tomek	05-23-2004 01:01 PM Paul Ibison	3	112
log shipping failover to stand by server Hi Guys in logshipping to fail over to stand by server do i have to do any role change as far as i know i have to run following script at the stand... biju george	05-23-2004 07:20 AM Paul Ibison	3	74
Access --> SQL Server synchronisation across the internet Hi, I am working on a low-tech project in Malawi, southern Africa. Wehave 13 offices each with an Access db. We have sending copiesof these... Philip Harvey via AdminLife	05-22-2004 01:43 PM Philip Harvey via AdminLife	0	80
After replication how to TRUNCATE the LOG After replication, my log has grown upto 300 MB and my Database size is of 20 MB.I want to truncate my LOG.Please let me know how to do it Help... Asif	05-22-2004 05:22 AM Paul Ibison	1	79
Problem after system recovery I just recovered a broken server with Windows 2000 server and Sql Server 2000. I had to format the hard disk and I recovered the database files (.MDF... aXel	05-22-2004 05:19 AM Paul Ibison	1	76
DBCC LOGINFO I am trying to get my log files to reduce in size, but when I run DBCC LOGINFO (MPlus) I get 491 rows with status =2 so when I go to shrink... Duncan	05-21-2004 11:09 PM Duncan	4	87
LOG File Maintenance Paul, you are starting to making me look bad, and I don't need your help for that:) "Paul Ibison" <Paul.Ibison (AT) Pygmalion (DOT) Com> wrote Marlene A. Roman	05-21-2004 04:35 PM Hilary Cotter	1	79
KB: 318075 - Merge Agent Error Hi, everybody ! I've tried to use merge replication but the replication agent failed with the following: The process could not deliver the snapshot... Mario	05-21-2004 12:24 PM Mario	5	70
Merge Replication Problem with separate Publisher/Distributor We are trying to setup merge replication using separate servers for the publication and distribution. The servers are in the same domain. The... PaulW	05-20-2004 02:57 PM nate axtell	4	74

Page 201 of 258

201

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off