Using a merge replication on a table I have an identity range of 100 with an update schedule of one hour. To this point this has worked fine with approximately 20-30 updates an hour being the norm. Recently we hired someone to do data entry from home and found that the range filled and pro...more >>

Have any of you folks encountered error 14294 - "Supply either @job_id or @job_name to identify job" while trying to create a publication using the wizard? I've tried deleting and recreating the subscription database on the subscriber - no luck. When I run sp_addpublication in query anal...more >>

I intentionaly created a record at the subscriber while replication was disabled to create nonconvergence. I selected 'Validate All Subscriptions' for my publication and was informed, as expected, that the table failed validation. I reinitialized the subscription and started the agent an...more >>

sql2k sp3 ***Important note*** execute sp_replicationdboption '<publicationdatabasename>', 'sync with backup', 'true' and also execute sp_replicationdboption '<distributiondatabasename>', 'sync with backup', 'true' have been run. Also, Im taking TLog backups of the user db's an...more >>

Hi, We are having a merge replication in play. It has been in play for past 1 and a half years working smoothly. At times we have weekly maintance wherein we drop and recreate the publication and subscription. Currently we are getting an error on the subscriber "The process could not query ...more >>

Hi, All! I have merge replication configured as following: Central Publisher (MS SQL 2000 Ent SP3a), and 3 subscribers - 2 - MSDE 2000 SP3a on Win 2k, and one on Win 98 (same version of MSDE). Access media - dial up. Subscriber on Win 98 works fine, but other two encountered such problem...more >>

SQL 2000. Transact replication. Immediate updating subscribers. I'm getting this error message on the agent: "The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated." How do I reinitalize a subscription witho...more >>

Hi I have following condition. One SQL 2000 Server and I want to distribute Accessreplication files. These files should sychn. between the Server via the ftp or http port. Is there anyone who can help me or any Internettutorial? Willi ...more >>

I have a dist/publisher on one server that will be going down to one day. In the meantime users will update the subscriber. Will the changes from the subscriber be uploaded to publisher then the publisher/dist come back online?...more >>

Hello, I've given up on replication because of timeout problems and the sheer amount of overhead. I've run sp_removedbreplication but all of the conflict tables and stored procedures remain. When I try to remove them, it says I can't because they are system objects. How can I delete these objects? ...more >>

I am trying to understand something I read in Want to replicate several OLTPish databases from 2000 to 2000. I assume I want transaction replication. I trying to understand one of the consiferations regarding text fields. I have read the following on technet: INSERT, UPDATE, and DELETE...more >>

I'm doing some testing with the ActiveX Merge control using VB 6.0. I've been running through fine, Initializing, running, and Terminating, the merge control. I stepped through the code and after a Run and before a Terminate, I stopped the job. I tried starting the job again and am ...more >>

What are the major problems that you can encounter with Transactional Replication with Clustering? Thank You, Daniel ...more >>

Hi, I am setting up log shipping for our SQL 2k (Enterprise Edition) servers here, using SQL 2k's inbuilt log shipping process, Everything so far works, log shipping, alarming and database failover however, when it comes to users/logins, what does sp_resolve_logins actually do? I ha...more >>

Hello - Anyone have any recomendations for good books on replication? I have SQL Server 2000 Programming by Vieria which has a chapter on setting up replication. I'm interested in some of the administrative maintanance issues, writing triggers with replication and programming replication...more >>

Hi, When I do the replication, it stopped until en error was occurred - Timeout Expired!!! I found that this error occurred after the foregin key is built during the replication process. Can anyone tell me the cause of this problem? Many thanks....more >>

Hi! I am going to be setting up replication that will support replication from server in one country to another server in another country both residing in the same domain. Do I need to have the same SQL Server Agent account running under a non system domain account on both the publish...more >>

Hi all, Trying to replicate a SQL2000 database with SQLCe (using .NET compact framework) the following error appears "The process could not deliver the snapshot to the Subscriber". I checked the most common items (Replication shared directory permissions, IIS (sscesa.dll) shared folder permiss...more >>

Hello. I've created a merge replication publication that works fine. I've created many row level data filters (simple WHERE clauses as well as JOIN filters). I now want to create a new publication with the same filters, but Enterprise Manager reports the following errors: 1. SQL Serv...more >>

Hello all - I have a merge replication publisher/subcriber running SQL Server 2000 and Windows 2000. I have serveral triggers running on the subscribers which notify an application when a replication data change has occured. This works fine but.... The problem is sometimes when a client...more >>

Hi all, Is there a way to slow the amount of data that comes across the lines in a merge replication? I tried using the slow connection agent and I also tried creating my own with real low bcp rates. But my 56K fram relay line is being over utilized and the data is not getting to the su...more >>

I am migrating from one machine to another using replication to transfer my databases. Before I terminate replication, how do I flush all my replication queues to ensure that all data which has been committed in my transaction logs has been replicated to the remote system ? Thx, John ...more >>

I had to restore a database that is involved with replication. After the restore the replication was broke. The log reader for the restored database on the publisher/distributor machine fails. What do I have to do get replication back. Somehow I want the restored version of the database...more >>

I currently have one server acting as a publisher and one server acting as the distributor and subscriber for transaction replication. This works fine. Now I want to add another server as another publisher. Can I use my same distributor server? Basically I want different servers all to...more >>

I currently have one server acting as a publisher and one server acting as the distributor and subscriber for transaction replication. This works fine. Now I want to add another server as another publisher. Can I use my same distributor server? Basically I want different servers all to...more >>

I didn't see a backup/restore newsgroup, so I figured I'd ask in here. We have an OLTP system (medium load) using SQL 2000 databases as the back end. Our current backup solution is full backups every night at 9:00pm, with tlog backups every half hour during business hours. Full backups ar...more >>

SQL 2000 Merge replication. The question below is theoretical, and posed by our developer with the hope that his application can deal with a subscriber going down, if it ever happens. Scenario: Clients randomly connect to either a publisher or a subscriber when they login. If the subscribe...more >>

Hi, I have set up SQL server to merge replicate to an Access DB, but I was just wondering if there is any configuration that needs to be done in Access. I have not seen any GUID columns in the Access tables, so I am wondering if that is something I need to configure from within Access. ...more >>

Hi, I configured Transactional replication with read only subscribers over Sql server 2000 machines with the log file and the database file on the same drive. Now due to the increasing size of the database, i want to move the transactional log file to a seperate drive. My questions a...more >>

Dear netters, I'm trying to set up a db architecture for a community school environment with the following restrictions: - each school uses a simple application, storing data in an an .mdb file - school data must asynchronously update a central server (SQL server) that stores data from all the scho...more >>

We use merge replication. We have a rowfilter that filter rows over 3 tables with a join filter. A_Project (id,project) A_Details (id,details,project_id) A_Involved (project_id,site_id) When creating a publication we have set a rowfilter a_involved.site_id='pc1738' It works fine! When...more >>

If I changed the table structures (e.g. add/drop columns, modify data type or create foreign key) on the existing tables or create a new table in the published database? Will it propagate to the subscriber? ...more >>

Source Os:WinNT 4.0, sp6a SQL Server Version:7.00.1077 Destination :Windows 2k SQL Server Version :7.00.1094 We are using Transactionl Replication with Updateable Subscription.When configuring we get SQL Server not found or access denied. Any Help is appreciated. -DBA...more >>

Hi all, I have a problem is that how to remove a publication comletely. I have used EM to remove it (Disable Publishing or Distributing). It show successfully. However, when I try to create a new replication, a error shown that as follows. ===============================================...more >>

I will be show the problem first and the real question is in last paragraph. Now I make the replication between 2 servers. The agent the be choosed in this case is merge agent. Most time that it work fine but it alway got the error in many time. This is my problem... I want to replicate from ...more >>

OK, I got my first three issues solved. Here is the 3rd: I'm trying to set up a second server as a publisher. This machine is completely behind a firewalll that allows no outside connections so I'm thinking I'd have to create push subscriptions. After I create the publication, I get...more >>

I have post to this news group and use my e-mail address. A day later, I received many junk mail (with subject namely Microsoft Critical Update...). Anyone know how to solve it?...more >>

SQL 2000 Merge replication. Scenario: Clients randomly connect to either a publisher or a subscriber when they login. If the subscriber goes down for awhile, everyone will connect to the publisher. When the subscriber comes back up, the publisher and subscriber are going to resolve their ...more >>

Hello, I have two transacional publications for the same subscriber. The 1st run for about 4 hours (lots of input data) and the 2nd run for about 2 minutes, every 10 minutes (inserts every 10 minutes). My question is: How can I set the 2nd publication to have priority over the 1st and actua...more >>

I am running SQL Server 2000, and for security reasons (company policy, not mine) I am required to run the server on TCP port 1981 instead of the default port. The second SQL server is running on the default port. I guess the problem with running SQL on a non-default port is that: ...more >>

The exact error message I am getting is "Error 7399: OLE DB Provider 'Microsoft.Jet.OLEDB.4.0' reported an error." I have provided the correct linked server and user parameters. However, this error message continues to re- occur. I have read a ton of different newsgroup messages with th...more >>

SQL 2000 Transact Replication. Immediate updating subscribers. How do I remove a single subscriber of a transact replication? I want to remove it so that I can reinstall it. I'm getting timeouts when the publisher is trying to connect to the subscriber. The error message is: "The proc...more >>

I've used the sysdatabases..category field (on our application server) in a piece of T-SQL to check whether a database is being replicated or not. If it is, the code uninstalls the publisher to disable replication prior to a job on the rep server that clears down the distribution database. What I'd...more >>

Hi, We have backed up our database that was developed for SQL 7, and uses some triggers and stored procedures. It then was restored on SQL 8. For some reason, triggers or stored procedures are not called for all users who log in (Via NT authentication). Everything works fine for the admini...more >>

While doing maintenance to a target system ( both are SQLSrvr2K ) I had some replication agents timeout. I was suprised because the system was down only about 40 minutes. Where / how do I extend the timeout value of my replication agent ? John Yard ...more >>

Configure Publishing and Distribution Wizard fails with the message: '(null)' is not configured as a Distributor. I have tracked this down by running sp_adddistributiondb and found that it fails because @@SERVERNAME is null. I have tried sp_addlinkedserver, sp_dropserver, starting and stopp...more >>

When setting up Transactional/Merge replication for a SQL2000 Server w/SP3 and MSDE2000 w/SP3 using queued updating keeping changes in SQL I receive the following messages: 1. SELECT permission denied on object 'MSdistributor_access', database 'tempdb', owner 'dbo'. The step failed. 2. EXECU...more >>

SQL Server 2000 (Service Pack 3a) I need to update some data on a table on my subscription server and then after testing go back and update the data on the publisher. This shouldn't be probelm as long as I don't update the primary key, insert a row or delete any rows correct? ...more >>

I'm attempting to set-up replication and would like to set the distribution db. I'm attempting to make the distribution db the same as the main db. I keep getting an error message stating that SQL Server Agent is using the system account and will cause replication to fail. I attempt to change the...more >>

Hello, I create a publication and get the messge, "A snapshot was not generated because no subscriptions needed initialization." I tried to create a subscription to it figuring if there was a subscriber maybe it would generate the snapshot, but the subscribing database cannot see the pu...more >>

Hi Freinds, SQL 2000 Due to a hardware failer , I have to recreate my publisher server. Old server is still up and running , so I am able to make backup and take care of whatever 'll need for second server. I have : DTS packages running JOBS scheduled NTdomain users and Replication dist...more >>

I am trying alter the design of a replicated view and push the change to the subscribers without having to reinitialize. I can easily accomplish schema changes to tables and not have to reiniatialize my merge subscribers. I cannot get the subscriber views to alter. I ran across a para...more >>

I am pushing from SQL2000 to SQL2000 using transactional replication. I have a number of these replications going, but a couple of them get an error everytime and have to be reinitialized. I have re-published it several times with no luck. error: The query processor could not produce a query plan f...more >>

Cant really seem to understand the exact difference between sp_replcmds and sp_replshowcmds from BOL. Using SQL 2000 Can someone elaborate more ? ...more >>

Hi, all -Background We have SQL 2K Servers running on Windows 2000. I have set up a DB to be replicated from a server inside of firewall to the other server located in DMZ. Firewall opened ports 1433 and 1434. The error I am getting is "SQL server Agent on "localserver" currently uses t...more >>

Hi there, Does anyone know how to get detailed information regarding the outcome of a merge replication of a specific run: Which records were deleted / inserted on publisher / subscriber? Which IDs / fields were updated on publisher / subscriber? Any help would be very much appreciated!...more >>

Hi I am tryingt o us sp_addartcile to add a table to my transactional publication. It is adding the table to the publication fine btu will not replicate the table until i break and re-create the subscription. I have tried re-initialising the table both in enterprise manager and using the sp_reini...more >>

I am unsure whether replication is the best solution for our scenario and would appreciate some advice. We have a number of MSDE databases running at remote locations logging local information. Each of these databases has just the data that is relevant to it's location. However the data is c...more >>