Hello All, I need some advice regarding changes to merge publications. We have an application with a SQL Server 2000 database that is the publlisher and many SQL Server CE databases that are subscribers. The application on the handheld keeps a daily log of activity so there are quite a lar...more >>

Hi I have an SQL server, which (for some unknown reason) will not start as a service. Whenever it is tried to start (either using SCM, NET START, or Enterprise Manager), it reports the following error: "System error 1058 has occurred. The service cannot be started, either because it is ...more >>

Hello. I'm running SQL Server 7, SP4. I'm using a snapshot replication to replicate to 4 different SQL Servers (all running the same version). I created a publication and subscriptions for all 4 servers. The replication works exactly as I desire. However, when I create a new publication an...more >>

Hello... I want to add an article to my publication. Do I need to drop subscriptions to my publication in order to add an article? If not, can I add the article and push only those articles that I added to my subscribers? I am using transactional replication. My publisher, distribut...more >>

sql2k sp3 Im trying to reinitial a subscription. I set the subscription to reinitialize, take the snapshot which runs successfully. The settings are set to drop/ create the tables. But it never happens. When I look at the snapshot agent job history step 1 has failed. It has the message: ...more >>

In a merge replication scenario if I deny access of Bultin\Administrators to login my server I get this error message: 'The process could not connect to Distributor 'MyServer' when I try to start the Snapshot Agent or Merge Agent. The Distributor is local. If I grant access of Builtin\Administra...more >>

I've noticed some strange behaviour when validating a subscriber against SUSER_SNAME(). Users have been noticing the following error: Merge Replication Provider: The merge process detected a mismatch while evaluating the subscriber partition validation expression. The problem can be resolved...more >>

Hi Everyone, We have recently started receiving replicated data from our hosting partner. When viewing the database via EM, the database icon is grey rather than the normal gold color. I have been unable to allow readonly access to the database and my efforts to un-check the readonly ...more >>

USE JCS EXEC master.dbo.sp_repldropcolumn 'Timesheets', 'RegularKM' When I execute the above command on my publisher, I get the following error. How can I fix this? I have to remove this column as well as another one, and add four more. Any help will be much appreciated!!!! Below is err...more >>

I'm a replication newbie and I used sp_removedbreplication as a first step to try to tear down replication for one of my DBs. It did remove all of the replication tables from my user DB, but all of the agents are still there, etc. I've tried running sp_droppublication, but of course it fails ...more >>

Hi again: 1. If the replication fails it send me an email of the error with an alert, that is ok... 2. i have to have to be a SA or a SA equivalent to see on the monitor the replica fail on the enterprise manager. 3. On the enterprise manager i have to go to publisher fail and sele...more >>

I designing DB, MS SQL2k. Problem with replication: Need two-way replication, but in case of conflict special user, expert, must solve such conflicts manually - not with Conflict Resolver interface, but with user friendly interface. I thinking of: transactional replication, replicate data to...more >>

Sir, I would request somebody to help me 'HOW TO SCHEDULE DATABASE REPLICATION TO AUTOMATICALLY DIAL THE MODEM AND SYNCHRONIZE AUTOMATICALLY at a scheduled period of time' I have a merge replication being configured and it works upon manually connecting and manually synchronizing. I would...more >>

After restoring a database from a production server to a test server, the publications in the original database is not shown on the test server database. The test server is running SQL 2000 with SP3a and the production server is running SP3. What am I doing wrong? Everything else on both s...more >>

I need to man some of my people with laptops in the field. What is the best way to deploy this kind of system and sync with the database once they come back to the office. -Kevin...more >>

Microsoft Consumer this is the latest version of security update, the "December 1996, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to pr...more >>

Dear All, I did try to set up 2 SQL Server to run replication. Both SQL Server running on win 9x platform with ver of SQL 2000 personnel. I did link up with 2 SQL server using sa account. One SQL work as an distributor and subscriber, and the second SQL work as an subscriber. When th...more >>

Hello, I'm having problems with my replication. Now the distributor and publisher are working fine. On the pull subscription end I get the error message, "Could not find the stored procedure ..." I know replication sets up all sorts of stored procedures, but in this case it did not. ...more >>

I'm trying to setup replication on a fairly big database (100 tables ish), of which most tables have PK as IDENTITY. So i have to set them to be NOT FOR REPLICATION on the table design. But going through Enterprise Manager takes *ages*, and the script that it generates is really complicated as ...more >>

Hi I have some problerm on "replicate indexed view on sql Server",I do bot allow the publish to be updated,but the option "replicate the view as a table" is always disabled,could u tell me why?Thanks ...more >>

Hello Everyone, I'm attempting merge replication between SQLSVR 2K SP3 and Access. The merge agent creates the Access database and transfers tables and schema information, however, no data is propagated to the subscriber. No error is generated. The merge agent status shows "Succeeded" and Last...more >>

Hello people! I couldn't really find a suitable newsgroup for this question (any pointer would be wecomed): I would like to know what all these connection means: Note:the SQL server uses ports 1500-2000 (so the database admin says) (this is the 'netstat' result - I have marked with '<-' the ro...more >>

Hi, W2K AE SQL2K SP2 EE We have an article published in several merge publications. Those publications are pushed to different subscribers. Everything works already for couple of months with no problem. It happened about a week ago. When someone makes an update in a table on the subscriber...more >>

I'm trying to replicate two tables from one database in one location to a copy of the same database (appx), however I am receiving the following error in the snapshot agent history: ---No delete permissions on table: tbl_1 --- This is a third party app, where I have discovered table mo...more >>

Hi All I have setup merge replication and I now need to disable it completely. After disabling it can I go into EM and delete the rowGuid columns from all my tables? There is no need for them any more. This is one more fallacy of SQL replication, disable should remove everything enabling ...more >>

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 >>