Hi, I have an unusual problem. In short, the Transactional Replication option in the Create and Manager Publications wizard is greyed out (ie: not available at all). Ther server is SQL 2000 server, output of select @@version below: Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31...more >>

I have two publications. One SNAPSHOT publication for all lookup tables. And one MERGE publication of three transactional tables. The lookup tables will be at every subscriber and will never change (should never change) I first sync the snapshot publication and this works fine. However wh...more >>

Hi I need to replicate 2 MSDE installations so I can only choose between Merge or Snapshot replications The replication need to update both the publisher and the subscriber It is only required to be initiated manually Any advice will be appreciated Shmuel Shulman ...more >>

What is the best solution for maintaining a database that is used for replication? I now how to implement table changes such as adding new tables or adding and dropping columns. I am more interested in how to maintain replicated stored procedures. I get the following error when trying to drop a...more >>

Hello! I have some merge publications, sometimes it produces conflicts. Can somebody tell me where I can find some information to avoid these conflicts?? Thanks in advance! -- Yoli ...more >>

Running SQL2K as pub/dist and MSDE 2K as subscribers. Using VB / SQL-DMO to run pull subscriptions: 1 merge, 1 snapshot and 1 transactional. When I create a snapshot and flag the snapshot as compressed, it appears that the user needs write access to the snapshot folder. When the snapshot is...more >>

I need to change a column that is a six character varchar called meeting_date to a datetime value. My plan is to create a table that stores a int value and a datetime value. Copy the primary key (an identity column) and converted the value to a datetime on the insert. Disable or alter all o...more >>

I have a one publisher and 5 subscribers at a distant locations, of these 4 locations are working fine, but one of my database is not getting synchronized even though the setting are the same for the database. This message was noticed after my system was infected with spida worm. When the syst...more >>

HI all I am using merge replication for mobile. the publication has 39 table and one of talbe call products, my pocket pc can down snapshot database sucessfully when product table without row filter. it always occurs "run" error if i set a row filter (product.productInactive=0) i...more >>

Hi Is it possible to use the MDSE Edition to synchronize the databadse wiha another copy of the datatbase again that is installed on MSDE? Thank you, Shmuel ...more >>

Hi all: i have two computers A,B with 2003 server. replication is running of A server , what i want to do that is to create snapshot at B server. i alway get access deny error when i try to start agent. Cheers nick ...more >>

HI all: I alway got a error "The replication agent is not registered properly. Rerun SQL server setup" when i try to start agent. Anyone can help me out here? Cheers nick ...more >>

I have one publisher , one distribution database and multiple subscribers. For some reason if replication fails on only 1 subscriber server how do i make sure what are the pending transactions for that subscriber. sp_browsereplcommand shows the pending transactions butdoesnt tell me exactly that...more >>

I have a cluster set up where in xp_sendmail doesnt work. I also dont have an SMTP set up to use xp_smtp_sendmail. Is there any other way that i can send emails to notify users if anything failed on replication. any help will be greatly appreciated. TIA -- Message posted via http://www.sqlm...more >>

We have recently implemented a relatively simple replication scenario, which appeared to be fully functional. Unfortunately, we discovered today that the subscriber is somehow missing or losing some commands, causing the two DBs to become out of synch. I would appreaciate any pointers ...more >>

We have set up a merge publication which has about 34 subscribers. Suddenly when i try to add a new subscriber, everything works fine until i start the merge agent on the subscriber. I get the error : Publication 'xxx' does not exist Invalid cursor position. I have included a part of the ag...more >>

Hi, I require to replicate data 2 ways across the internet. I think merge replication would be the best way to do this. How secure is it across the internet ? Is there anyway to create a file out of differences to be applied to another database. I am using SQL Server 2000...more >>

How to resolve this problem Cannot DROP PROCEDURE 'duplicate _in_combolists' because it is being referenced by object 'combolists_unique'. Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi all My company is using Microsoft SQL Server 2000 on a Windows 2000 server, in its head office location. We have a second office, which is connected to head office via a 2Mb fixed link - users of the databases in that second office are connecting directly to the server in the head offic...more >>

I am currently running a SQL Server 2000, which hosts the replication publisher & distributor of a large merge publication DB. The current NT 4.0 server is scheduled for complete replacement and upgrade (to Win Server 2003 w/ SQL Server 2000) and I am looking for best practice recommendations...more >>

I am currently running a SQL Server 2000, which hosts the replication publisher & distributor of a large merge publication DB. The current NT 4.0 server is scheduled for complete replacement and upgrade (to Win Server 2003 w/ SQL Server 2000) and I am looking for best practice recommendations...more >>

Hello, I have a merge replication, and in a table that is being replicated I need to delete the index. May I do this? Do I need to run a stored procedure to do this? In another table being replicated I need to add a field in the index. May I do this? Do I need to run a stored procedure to do thi...more >>

Hi, SQL 2000 I disabled the transaction replication from publisher server and everything cleaned up from publisher, but I still can see agents under subscription on subscriber server. How can I reomove the agent from subscriber server ? Thanks. Pat ...more >>

Greetings, I would like multi-language is available in SQL 7.0/2000 Replication. Kind Regards Sarbjit Gill ...more >>

SQL 2K SP3 & Win 2000 For some reason, I am missing publications in my Replication->Publications folder that exist in the Replication Monitor->Publishers->ServerName, here they have the red X. When I attempt to delete them out of the Replication Monitor folder I get the error message....'SQ...more >>

I have merge replication setup between two machines and I programatically created a page to send me an email on success or failure of replication every hour. I already have a page setup to run a stored procedure (msdb.dbo.sp_start_job) to restart a "Transactional replication" process, bu...more >>

In a MSCS SQL 2000 SP3 cluster environment I plan on implementing transactional replication. Distributor and publisher are on the same server (quad processor machine). I Intent to publish a relatively small db (@ 60 articles) to a subscriber in a remote SQL Server cluster and would like to h...more >>

Hi All: if a database is publication database, so i can not modify this database structure unless i drop the publication first. is that any easy way to modify publication database without dropping publciation first? Cheers nick ...more >>

I've got a 14GB (and growing) SQL2000 DB (lets call it ARC1) that I need to keep synced with another DB (lets call it DOR2). DOR2 is only accessible via FTP - no direct connections... The sync only needs to occur on a monthly basis and DOR2 will have no updates and is really only used to sup...more >>

How....Why.... Running SQL 2000 SP3 & Win 2000 Adv Srv. I cannot get rid of the Red X that appears in my replication monitor. I have run 'sp_MSload_replication_status' to no avail. HELP!!! How can I get rid of this?? The X appears on the Replication Monitor->Publishers->servername...more >>

We are having a performance problem when adding new subscribers to our merge publication. The problem is not in applying the snapshot; this completes in 2-3 minutes. The problem is the first merge after the snapshot is applied. This merge is taking 45-60 minutes and the duration has steadily ...more >>

I'm looking at migrating the AccessDB backend of my website to SQLServer. There will be a copy of the SQLDB sitting on my PC and another copy sitting on the web server. The copy on the PC will be considered the master. How does replication work when access to the replicant is via IP? Als...more >>

When I set up Merge publication the wizard tells me the rowguid column will be added to a list of tables. After I create the subscription and run Merge replication I see that rowguid is added to all tables, even the ones that already had a column with a uniqueidentifier. Did I do something wro...more >>

Hi guys, I have SQL Server 2000 on the server, plus MSDE backending to a VB app on client workstations. I've setup continuous push merge replication, with the server as publisher. It takes about 30 secs for changes to replicate either way. I'd like my application's users to be able to hi...more >>

HI, sql server 2000,uni directional transaction replication with initial snapshot . Can not be simpler than this. My database has around 100 tables and ever time i setup replication, i have to make sure that none of the referential integrity constraints are copied over to the subscriber b...more >>

Hi, I am trying to create an application to replicate data from Informix to SQL Server 2000, I've already went thru MS article about how to use the Replication Distributor Interface but I am looking for some more samples on using Informix Is there another way to do this kind of replication? ...more >>

Hi, The replication between 20 databases has been running smoothly since last 5 months. In some time a symbol is displayed in the replication monitor. Its a arrow symbol with blue color like indicating 'retrying'. (1) What it the reason if it occurs in Replication Monitor-->Publisher-->D...more >>

Hi, I am dealing with merge replication for 20 databases(each of size 2 GB). Average transactions per day is 3000. 1. I want to know, is there any limitations in the number of publication that can be set in a subscription(now we have 20 DBs). 2. The updates are merging in batches of ...more >>

I have replication set up from server A to server B. One of the tables used in publication has an identity column but is set up for (NOT FOR REPLICATION) . I also have the same setup on subscriber too. Am I getting this error due to that. {CALL sp_MSupd_table (NULL,NULL,NULL,NULL,'N',NULL,NULL,...more >>

Hello: I want to know how many synchronizations have been made at all. Is there any system table or something like that where I can find this number? Thanks a lot Juan ...more >>

For DTS, how to confirm that number of data reached the destination server is correct and to confirm that there is no loss of data at the network. ...more >>

Any ideas on how I can decrease this? --Thanks, Kristy ...more >>

In my limited reading it seems like transactional replication is the thing to use to have some type of failover system. We want a nearly live backup of several databases in a differnt city. We would only switch over if the local dababase would be down for an extended period. Does this m...more >>

When I first created the Merge publication it created a snapshot job. Then when I created the subscription it created a Merge job. Now the Merge job runs the updates against the subscription database as it should but I can't figure out how to apply any more snapshots. There is no distribution ...more >>

We have one server that is both the Publisher and Distributer. We need to move the distributer to a separate server. Does anyone know of a good article for moving the distributor or the steps involved? We are doing both merge and transactional replication. We have 450 subscribers now and...more >>

In merge replication I know that it uses queuing, and I tested it by disabling the SQLAgent at the subscriber for awhile and updating at the publisher, then restarted the SQLAgent at the subscriber and the data downloaded to the subscriber from the publisher correctly. My question is: What...more >>