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