Hi, I have Server A(Publishing Server) and Server B(Subscribed Server) which are in replication. The replication type used is "Transactional Push Model". My requirement is to 1. Drop Table1 which is available in both Server A and Server B 2. Drop Table2 which is available in Server A an...more >>

I'm working on an algorithm to backup data from pocket pc sql server 2.0 database involved in an merge replication with sql server 2000 sp3 with rda in case that replication fails from whatever reason. My question is if I can determine on a sql server ce 2.0 table involved in merge replication wh...more >>

Hello I am face the following problem. Invalid object name 'sysmergearticles'. The merge replication is falling please help me. Best regards, FDB ...more >>

This question is also posted in public.sqlserver.ce, Sorry! Scenario: SQL 2000 with 3 tables A, B ans C related to each other with FK constraints. B has a relation to A and C has a relation to B In the FK columns the option 'Enforec relationship for replication' is unchecked Merge replic...more >>

How do you setup replication without using window authentication when = trying to replicate from a domain to a workgroup in the DMZ, without = using trusts?...more >>

All, Sql 2000, Server 2000 We are going to be implementing an IBM FastT SAN. There is a feature called flashcopy, is there a way that sql can be used with this feature. Essentially it takes a snap shot of any file at that point. I doubt there is a way to use this feature for backup and...more >>

I have a database of approx 700mb that I want to replicate to one of our regional offices. I would like to know if it is adviseable to split the database into 2 types of replications. 1. Merge 2. Snapshot. The reason for 2 types of replication is that I do not require all the data to be m...more >>

Hi, I am trying to replicate my database in SQL-Server on Server1 to Server2 Its a Transactional Replication using push method. I am getting the following error and unable to figure out why. Can anyone help me out with this ? -------------------------------------------------------------...more >>

Does anybody know what will happen when I use different functions to filter rows on articles (dynamic filters). In some articles I want to filter using the HOST_NAME() function, in other rows I want to use the function USER_NAME() Is this possible or should this be avoided ? ...more >>

We have a merge replication on a database containing dynamic filters. At a given moment one of the clients gets the following error during replication. 'The process could not make a generation at the Subscriber' The error message is 'Cannot insert the value NULL into column 'nicknames', table ...more >>

I have two Push Subscriptions that I cannot delete. When I right click on them the only option that shows is 'help', which doesn't. The articles and publications not longer exist. I have tried to delete them using sp_dropsubsciption, but receive an error stating "Invalid object name 'sy...more >>

I am using SQL Server 2000 transactional replication (one- way transfer). I have replication set up on my two servers. How would I obtain a list of outstanding replication transactions? Thanks, Mike ...more >>

I have read many articles stating that you shouldn't really use transaction replication to deploy a warm standby server but due to cost constraints this is the method that we have to use (we don't want to upgrade to SQL 2000 Enterprise Edition). Our environment is: Server A - publisher and ...more >>

I have two databases one is in head office and other is at factory site. I want to share information between these two sites. I have tried to complete setup of Oracle Advance replication but failed to complete with errors If Any body can help please go fast I am in need .... *** Sent vi...more >>

Dear all, I need your advice. The situation is as follows: Site 1: Customer Database with RegionCode = 1 Site 2: Customer Database with RegionCode = 2 Site 3: Customer Database with all RegionCode Can we do the replication (push) from Site 1 and site 2 to one database at Site 3? If it ...more >>

Anyone knows any statistics about this two replication. I ran a test and found Merge Replication is significantly slower than Transactional Replication. However, I would like to know why it is slower besides the two way checking to solve the conflicts. Regards, ...more >>

I want to create a script to set all my triggers to Not for Replication, = can someone please provide an example of alter trigger. Is it as simple as; ALTER TRIGGER triggername ON tablename FOR Insert, Update, Delete or Whatever NOT FOR REPLICATION ? Thanx!...more >>

Hello All, I have a table whose column is populated by a sql function, using formula property of the column. Is there a way to replicate just the value of the column and not the formula? Thanks Senthil...more >>

-- "I can do it quick. I can do it cheap. I can do it well. Pick any two." Mario Splivalo msplival@jagor.srce.hr...more >>

Hello I am face the following problem. Invalid object name 'sysmergearticles'. The merge replication is falling please help me. Best regards, FDB ...more >>

Hi, We are using merge replication in our company with one server configured as the publisher and distributor and about 30 subscribers. We are looking at a scheme to move data from a replicated table to a non-replicated one. I was thinking of using a Job to move the rows meeting the specifie...more >>

Hi all I hope someone can help. I currently have three servers replicating using Merge Replication. Somehow the generation number on each server has been reset to 0. I now have transactions in the MSMerge_Contents table and MSmerge_Genhistory table that are not being replicated. When the merge agent...more >>

While in Ent.Manager viewing the merge agents there should be 68 in my organization but the count is only 64, nobody deleted their subs and none are expired, they can still sync, but the agent disappeared !! why ?...more >>

when sinchronize this error is show: "el proceso no pudo conectar con subscriber 'PCP'" The process can't connect to suscriber. Please, any IDEA, is accept. Thanxs Gabriel Argentina ...more >>

The duplicacion is MErge. when sinchronize this error is show: Error calling rempote procedure Please Help! Gracias Gabriel ...more >>

Hi, it's me again We have merge replication setup between three servers, a push to one server and a pull to the other server. There are many tables which use identity fields. We are not using identity ranges. All were created with the not for replication option on the identity declaration....more >>

I am having problem getting the transaction log of a db that is being replicated to shrink even after performing a backup. There is about 500 MB of data in the database and the trans log is almost 4GB. Dbcc checkdb returned no error but dbcc opentran returned the following message: Replic...more >>

How would I replicate data from Oracle to Microsoft SQL. I want all changes across but if something gets deleted in the Oracle database in don't want it deleted in the Microsoft database. Thanks Hilmar...more >>

I have been receiving the following errors from time to time during my nightly processing. At this time we replicate a large amount of commands. The funny thing is after these errors occur once, the next run is successful. General network error. Check your network documentation. The er...more >>

Hi, Can anyone tell how to solve the error message returned from distribution agent that is the subscription(s) have been marked inactive and must be reinitialized? Actually I searched some articles said that is the MS SQL Server bug and need apply latest version but we are already ap...more >>

I do a merge replication between Sql server 2000 and SQLCE 2.0 On my SQL2000 I have 4 tables i want to merge (specific columns only ) in 1 table for Merge with my SQLCe ( the table will be use for read only) [U]Question 1:[/U] What is the best pratice for keep the information update? Run st...more >>

Hi There, I have install MSDE (pull subscriber) and sql 2000(publisher, distributer). I could able to run the initial snapshot in the publisher, but when i try to run or click start synchronizing for the pull subscribtion the following error message is coming. I think there is some configurat...more >>

Hello I want to call sp_dropmergepublication in a trigger. Unfortunately I get the error "Server: Msg 15002, Level 16, State 1, Procedure sp_droprole, Line 1 The procedure 'sp_droprole' cannot be executed within a transaction. Isn't it possible to drop publications in a trigger Does someone...more >>

Hi, My problem is, that new identity ranges never gets assigned to a table. After my configered range of 1000 identies is used, the user can not ad new records until i run sp_adjustpublisheridentityrange. If users (connected to the publisher server) try to add records they get the following e...more >>

Hello all, In our environment (SQL Server 2000 w/SP3 on the server and MSDE 2000 w/SP3 on the clients), we have setup 2 Merge Publications for dynamically filtered data and static data. The reason for this is to work around limitations of what schema changes can be done on tables that are fi...more >>

Hi all, I have to ship changes of a database to a remote location, where the internet connection is .... unreliable. Technically the transactional repl. would be OK for me, but I can not enable any port on the corporate firewall, because of security reasons. Is it possible to deliver the chang...more >>

I have removed all the publications for a particular subscriber from the publisher but on the subscriber it still shows the subscription is still being there. How can I removed these subscriptions info from the subscriber....more >>

I am having an issue with sp_MSdistribution_cleanup. The command I run is: EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 12, @max_distretention = 72 It runs every 30 minutes daily . I would expect this to keep 12 hours of replicated transaction after they are replicated. It is...more >>

I have done an update query to a SQL database that has gone horribly wrong. Is there any way that I can restore a database to a previous time? I would like to undo the update query if that is at all possible. Thx, Joe ...more >>

I'm trying to run a script that restores a DB that I want to completely overwrite. I get the following error 1> 2> Msg 3101, Level 16, State 2, Server , Line Exclusive access could not be obtained because the database is in use Msg 3013, Level 16, State 1, Server , Line RESTORE DATABASE is t...more >>

Hi All, I have a strange problem, the merge replication sometimes doesn't insert the row on the merge (it seems that it fails I don't know why) and is not dumping the entry on the conflict table so suddenly my record dissapear without trace. One tip: I have a couple of extra rows on my...more >>

Dear Friends I want to add a column to the table which is in the replication please suggest how i can achive the same. I am using Merge Replication. Best regards Sharad...more >>

Dear Friends I have setup merge replication for the stock database. and facing strange problem i have ID as identity column and the same is having property not for replication. I am getting error for the primary key voilation and found out the problem that the Site2 is giving the same ...more >>

I am having trouble with Merge replication between two databases on different machines using an IP address. The error message is as follows: "The remote server does not exist or has not been designated as a valid Publisher. The step failed." We currently have 2 servers both on the same n...more >>

Configuration: Proliant ML350 , Win2000 Server, SQL Server 2000 internal PCI ISDN adapter ASUS P-IN-100(W,D) This server has number of merge replications (as publisher) and does up to 15 replications every night. From time to time (once a week or 5-6 days, but always during replication) the ma...more >>

Hi there Is there anyway to export an exact version of a database to CD so i can then go to another site and import the image of the database onto their server. Ive tried but cant find the best file format and also i keep getting problems such as auto increments dont get carried across in the tabl...more >>

I am just wondering what would the best computer specifications for running a perfect transactional replication. The database would have around 50 transactions per second Pentium 4 2.4GHz Dual Processo 2 GB RAM EC 33.6 GB HDD X 5 @ 10,000 RP Windows Server 200 Anyone with any suggestions or m...more >>

Hello All - I have a push merge subscription using Sql Server 2000. The publisher & distributor reside on the same host. I would like to be able for clients to determine the status of their merge agent at the publisher. This would be used as a verification at the client, that their merge ...more >>

Hello: I've been musing about the requirements of making a CE port of an application I wrote so that the data (a classic tasks/project set of tables) can be carried on a CE. My questions are... I know that CE and MSDE have a replication feature, but what about replicating to other database ...more >>

I have serious problem regarding merge replication. After couple of pull subscription synchronizations, data loss occurred in several tables (both publisher and subscriber databases). Publication has 62 articles, but only few are affected. Agents reports several errors (including really nasty "g...more >>

Strange things are going on on our server. When i look in the replication monitor, the list of snapshot agents is empty. It says : unable to show items at the moment. Another strange thing is when i subscribe to a transactional publication and i start the snapshot agent it says : 'A snapshot was...more >>

We try to perform replication. We configured our server for replication. Steps that we followed: 1) Create Publishing and distribution wizard 2) Create Publication wizard 3) Create Pull subscription wizard We did not meet any errors until while doing them. But at the end of the process in ...more >>

I have a couple of questions relating to a merge replication database. 1. I was unable to add a column to a table being replicated using EM, but succeeded using sp_repladdcolumn. When I tried to drop another column using sp_repldropcolumn, I get the following message: "ALTER TABLE DROP ...more >>

I had a problem with my replication, and microsoft KB said they already have a supported fix for this error. how can i get it? I've tried to follow this link http://support.microsoft.com/default.aspx?scid=fh;EN- US;CNTACTMS but it seems to complicated for me. I didn't find any SQL Server i...more >>

Q 1: Is ist possible to run one single SQL statement which adds data to a table (on publisher) which exceeds the assigned identity range of the publisher ? (e.g. Identity setting 100,100, 80%, adding 150 records) Q 2 If the replication agent is scheduled to run every 1 hour, when are new id...more >>

Hi I have setup merge replication to run between two SQL 2k (SP3) across the internet. But while selecting the articles via EM I forgot to select "Identity Resolver" for a particular table. And this is creating havoc in that table I have to solve this by dropping the article. Or is there any oth...more >>

We have a sql2k db as a Distributor, with a few servers geographically scattered acting as subscribers (backup). I'm setting up transaction replication, however, is there a way to rollback in the event of dataloss on the Distributor ? Eg : 'delete tblProducts' run on the distributor. Wouldn...more >>

Hi All I have a curious problem. I have a replication to my branch that has been running over 8 months. Everything works fine but once in a blue moon I get this problem Replication Agent reports all replication is successful however, 1-2 rows of data in the branch data does not match with the...more >>

Hi, at the moment I can create tables for subscription database from the initial snapshot of the published database fine. But when it comes to creating views/stored procedures/functions. The Subscription database creation fails because of a hierarchy/ordering problems of views/stored procedu...more >>

We have SQL 2000 server replicate to another box I just found replication stopped! and distribution database was marked SUSPECT I am a SQL server newby, I checked sysdatabases table in master database and foun the status column is 280 and status2 is 1090519040 Is there any way I can quickly reco...more >>

What are the basic rules for the publisher and subscriber when you wish to make a database change like adding a column? - make the change to both databases - just one and replicate the change - disable publishing, drop subscriptions before, etc. Thank you so much ( as I read the c...more >>

We get some conflicts as child record cannot be replicated becos parent record has not replicated yet. when they replicate next time conflicts goes away. How or where do I find the order of tables/articles that replicate in a merge replication. pls help...more >>

I have two servers in a merge replication setup (linked every night using an ISDN line). I wish to add a new subscriber to this but I am not sure if I need to do a new snapshot. I was thinking of using the latest backup from the publisher and recover this on the new subscriber - if I do this wil...more >>