My sqlce program works fine within intranet using usb cradle. It can sync data via both http and https protocol. To verify sqlce agent, both http://hostname/sqlce2/sscesa20.dll and https://hostname/sqlce2/sscesa20.dll can show "SQL Server CE Server Agent" in browser. That's work terrific in in...more >>

We are using MSSQL2005 (64-bits) and replicating data from oracle to mssql2005 DB. Some replication jobs failed and it shows 'data conversion failed' error MSSQL_REPL20037. Any idea on it ? I can't find the error in online book. THanks in advance! ...more >>

Hi, We have two SQL Servers, both running 2005, located in separate domains in different physical networks connected by VPN. The servers can "see" each other at IP address level and can resolve FQDN's correctly. The servers are named like this: abcserver.domain1.local abcserver.c...more >>

I am guessing when they do this it will require a re-initialization of all the current publications. Is there anything else that i need to know about? ie. does it work? any caveats i need to know about. Web search doesn't turn up much. tia -comb...more >>

Hello there I've create transacional replication from two databases. At the publisher new field added to all the tables i mark as replicated: msrepl_tran_version It cause damage to my database. What i need to do to ged rid of them? and what i need to do so they won't be created again? -...more >>

Hey guys. my plans were to setup replicatin for test from sql 2005 to sql 2000. I could see the 2k box from 2005 but not the other way. Is there something i'm missing or it's not doable? Please let me know. Also, i can't replicate from 2000 to 2005, right? can i replicate from 2005 to 2000? th...more >>

SQL 2000 sp4 - I have an existing merge publication, I want a new table. I assume I would do the following, however I have some questions: I assume I call sp_addmergearticle, for the @article param, specify the new table. I also assume I would need to call sp_addmergesubscription, correc...more >>

How kan i, Replicating e-mail addresses, fax numbers and Distribution Groups from sql database to Ms Exchange 2003? Kind regards...more >>

During a memory- and CPU-intensive nightly database update process, the merge agents (running on the server) for two subscribers failed with SQL Server Error 8645 (A time out occurred while waiting for memory resources to execute the query). It's not surprising to see this error, but the fact th...more >>

How do I replicate permissions for articles in a merge repl publication? I've read that if you replicate the syspermissions table, the permissions will follow the objects, but I can't figure out how to view/include a sys table when defining the articles. I've generated a 'set permissions...more >>

I have a customized scripting procedure that will script all objects in a given db. My problem is, on a db set up for replication, I don't want to script all of the objects that the system creates to manage replication -- just the original db objects. I there way to isolate replication obje...more >>

Hi NG Publisher: Win 2003 Server SQL 2000 - SP3a Subscriber: Win 2000 - SP4 SQL 2000 - SP3a After many headaches with dog servers and virtually non-existent bandwidth, I have finally got my Merge Replication up and running OK. However, I have inadvertently selecte...more >>

Hi I posted this earlier in the week, i upped the inactivity threshold to 120 minutes but no joy. The agent is still running however as when i right click on it i get the option to stop agent. Any ideas Thanks Nick...more >>

We have a Merge replication on SQL 2K with same publisher/distributor and only anonymous (laptop) subscribers. How often is it necessary to create new snapshots when the laptops are synching frequently (every couple days)? Also, is new snapshot needed only if structure changes? As you can te...more >>

We're trying to pull approximately 50 tables out of a database of 16,000. Unfortunatley none of them have primary keys, they are all keyed by multiple fields (mostly effective dated). Ideally we'ld like to see only changed or inserted records be loaded into the subscriber. (Those would be pr...more >>

Do we need to do any maintenance tasks on distribution database in transactional replication after the replication is setup..??? Any advise... Regards, Ravi...more >>

I try to merge replicate a database containing one table but fails to replicate if there's over 127 columns in the table. 127 columns and less gives no problem, but 128 and more throws a native error 0 and no description. Now, in the help file they say that merge replication has a limit of 2...more >>

I am trying to filter data replicating to mobile devices based on the current user. I am using merge replication. I have read the examples where you can leverage the value of SUSER_SNAME() or HOST_NAME(), but what if you need to use an application specific User ID? You see, my mobile user...more >>

Hi All, I have tried to move one of my heavy snapshoot publication on testing environment from regular snapshot to compression snapshot but did not get improvement. I was surprised because I have network latency (IL to US) and the original BCP text file size is ~32 MB . I...more >>

Need to know how to get tables with an Identity column to replicate. They show up as non-published articles? Please advise. Thanks in advance!...more >>

Hello, everybody, I'm using SQL 2000 SP4 on W2K & W2003 Server. In the last 2 weeks, I encounter a very annoying problem with the replication: "The merge process encountered an unexpected network error. The connection to Publisher 'AR-MAIN' is no longer available" - error number -214719946...more >>

Hello all, I am a newbie when it comes to replication. I have read the BOL but I was overwhilemed with the amount of information about replication. We are planning to have a server with sql server 2005 and disconnected laptops with sql server express. How would replication work in this scen...more >>

Hi, I am using SQL 2K standard and have created a transactional replication between two sql servers using push subscritpion. It is working fine. Now I want to add a clustered index in one of the published tables and I get an error message saying that "Cannot alter the table because it is ...more >>

Hello there I've tried relication many times before. It seems that it didn't always worked ,because I still used System account instead of replacing it with another account. Now when i'm trying to give it another account, the agent become unuseable. What i need to do to create another u...more >>

Hi, I hope comeone could help with an additional query i have. I submitted a post just previously asking how I can configure replication in the situation where I have a database (call it db1) and a copy of db1 (call it db2). db2 was created via: 1. detach db1 2. make a copy of db1 (call i...more >>

Hi, I was hoping someone could give me some insight into issues I have with SQL 2000. I am required to move a production database to a new sql server (on another machine). Due to the size of the database, I will move it during a very narrow timeframe which i have been alloted, when i expect...more >>

Hi, I have used the 'Disable Publishing and Distribution wizard' to remove all publications and subscriptions and it went successfully. But why is there a subscription item listed in the 'Subscriptions' folder under the 'Replication' folder in the SQL enterprise manager in both the publis...more >>

I am creating pull merge with filtering. I know I can filter the replication after it is going - can I filter the snapshot? I will need to create (initialize) the initial data, but I don't everything out there - I want it to honor the same filters. Can this be done? If so, how. Darin *** S...more >>

newbie to transactional replication (replication in general). I have one server that is publisher/distributor. Another server as subscriber. both sql 2000 sp4. I have setup replication and when trying to apply the initial snapshot it says that it can't drop table as the table is in use. I...more >>

I am new to replication and have setup Merge replication (SQL2k) to synch with laptops. I made some data changes on the Publisher and then synched with the laptop and it got the new data. Then, I added a test table and 2 rows of data on the Publisher. After a few minutes I tried to synch ag...more >>

We are testing with the CTP Sept. version of SQL 2005 in hopes of moving to the released version of SQL 2005. We have a table that has an autoidentity range, with "Not For Replication" set to yes. (Is in a merge-snapshot publication.) In SQL 2000, you used to be able to uncheck the constraint ...more >>

Hello, We've been using merge replication now in a live customer environment for several months with only one major issue; every several days to several times a day, the merge agent fails with the following error message: The process could not enumerate changes at the 'Publisher'. (Source: ...more >>

Running - SQL 2K Win2K When I attempt to create a pull subscription from Server A to Server B, I get the error message, Error 208:Invalid object name 'syspublications'. Invalid object name 'sysextendedarticlesview'. I have done some research & have read everything from remove replicaton ...more >>

Any help would be greatly appreciated I get this message at the publiser on small business server 2003 I have tried the following: Reboot the server Scheduled the job to run over the weekend when the server is not being used Checked that the process is not being blocked by another process ...more >>

Hi, We have about 50 databases all of them are being merge replicated. On a average , each database has about 150 tables which are published. We get meta data retention error atleast one per week on a average. We have two category of users, Users at the publisher server when they log (dialu...more >>

Hi, I got the 'The identity range managed by replication is full and must be updated by a replication agent...' error when attempting to resolve an insert conflict. I ran sp_help and dbcc checkident on the table and found that by the time I tried to resolve the conflicts, the merge agent had ...more >>

When we try to run the Configure Publishers, Subscribers, and Distribution from the EM Wizrd, we get the Error 208 invalid Object msdb.dbo.MSDitsributiondbs and the setup quits. The server is a Cluster, with Log Shipping. Select @@Servername returns the correct server name. The interesting thing...more >>

We've been running transactional replication with updatable subscribers for several months now. his morning we are seeing these errors in the LOG and QUEUE READER logs. You Receive Error Message: "The replication agent is not registered properly. Rerun SQL Server setup. Any ideas? SQ...more >>

I got 'could not execute sp_repldone/sp_replcounters on publisher' error on my logreader agents but my log reader agents are still running and transferring data. what made it cause that..is there any fix for it..??? I have checked couple of tables and seems like everything got replicated. ...more >>

How can I setup an anonymous pull subscription, using the sp_ scripts = for the pull subscription & pull agent, for NO SYNC? --=20 Jude...more >>

I have 2 sql boxes setup in a VM environment, with neither of them = knowing each other (No Trusted Domains) Here's what I have accomplished: I was able to put the entry in the Hosts file for each Put an Alias for each box in Client Network Utility Setup the Publication - allowing anonymous p...more >>

I have about 115 sql ce databases syncing to about 100 sql databases. The sql databases are all on the same server. We want to move the sql databases to a new server without any data loss. Does anyone have any good ideas on how to accomplish this or links to resources about this kind of thi...more >>

Is it possible to use two distributors for one publication database? ie i would like to implement one publication for some tables using one distributor and another publication using some other tables on the same server.db using another distributor ( to reduce the size of repl tables on distrib...more >>

Hi: I made a change to the stored proc in the publisher database but the change did not get replicated. I should not have to run the snapshot agent again to do that. Please let me know how can this be easily done. Thanks ...more >>

Hi all: I having big performance issue of merge replication. I using merge replication in sql 2000 and PDA is a Subscriber. Due to the large number of data need to transaction between sql server and PDA, i really need to get the replication performance faster? any ...more >>

I've got a client with a hosted merge replication publication. They're occasionally running into FIFO caused conflicts due to FK constraint violations. My PROBLEM, however is that rows show up in the conflict_<pub_name>_<article_name> tables, and then later they're mysteriously gone. B...more >>

Can replication be done over port 80 with SQL Server 2005? This would remove the "hotel firewall blocks port 1433" scenario......... Thanks ...more >>

Hello, We have transactional replication running and we would like to add one more column to an article. What is the minimum amount of work needed to be achieve this in a clean way. Do we have to stop replication? Or is it enough to drop subscription and modify filter columns and add the su...more >>

Occasionally, our replication between our offices stops, almost always due to a general network failure/pesky WAN link. Is there a table or sp that I can periodically query to detect if replication is still running, or if replication has stopped and why? I would ideally like to call this e...more >>

Ladies / Gentlemen Is their a Paper / Guide / Book that Explains how to set up a replication environment using MSSQL Server. I was thinking of using MS SQL Server Express at all the client locations with MS SQL Server Standard Edition for the Headquarters. Any help would be appreciated....more >>

Hi, I 'am looking for interesting SQL Server books on replication especially for 2005. Thanks in adavance for advices, Laurent ...more >>

Hi NG Publisher: Win 2003 SQL 2000 SP3a Subscriber: WinXP (Moving to Win 2000 SP4) SQL 2000 SP3a Pull Subscription Connection via web on 64k dial-up. The DB is 3GB. Originally synchronised on LAN. Publisher box now shipped to new location. Only access is via R...more >>

I am a newbie to replication and made the following attempt established a link between 1 clustered server and 1 regular server performed a new publisher [w/ anonymous subscribers, transactional replication, continuous], new snapshot folder [ took 10 hrs to complete], new subscriber notice...more >>

Hi, I was curious to know if one subscriber can subscribe to two publishers for the same table (merge replication). I use 3 SQL Server instances: - The subscriber made its subscription to first publisher. - For the second publisher, I made the subscription by using the option which say "the sub...more >>