I would like to set up merge replication where the users develop and test data in the subscriber database and then replicate to the publisher via the ActiveX merge replication control in a web page. How can I set up security so that the users can only write changes to the publisher via replicat...more >>

I'm replication through a VPN connection over the Internet and the Publisher and Distributor is located on the same machine: Publisher/Distributor-> Local snapshot folder -> VPN/internet <- Subscriber The subscriber has access to the publishers local snapshot folder. When I chose to compre...more >>

when i setup the replication feature in SQL, it added a column titled "rowguid". why was this added to my tables? now i can't access any of my table through my xml program. any suggestions!!...more >>

What am I missing? The process could not connect to subsciber LSCOREPORT. Full message:Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection....more >>

Hello, Is it a good ptractice to rely on SQL replication to send updates to a remote SQL cluster to keep a hot for disaster recovery. Thanks...more >>

We are using Merge replication to synchronize data. It is done between two SQL 2000 servers and SQL CE The Architecture is as follows There is one head-office (HEADOFFICE) SQL 2000 server which is a publisher and replicates data with one counter (COUNTER) SQL Server 2000. The COUNTER server has ...more >>

The views in my database are articles within the publication of this database. If I make changes to these views - with alter view , or in design mode - these changes aren't uploaded to the subscriber after a sync. Does anyone know how I can force a view update at the subscribers database?...more >>

We are using replication in L.A & Mexico. Right now, the replication doesn't work. Someone tried to save the data in Mexico. The below data is not normal. I don't want to stop replication. I just want to delete 1 row on table. But, I cannot find the data on the database. Where is the below da...more >>

If I am not wrong, failover clustering assumes the backup database to be a replica of the original database. Does failover clustering itself perform the data synchronization?...more >>

We are getting ready to roll out our first replication project to a small test group. I think we have everything set up, and it is working pretty well. I am a bit nervous though, as we occasionally observe errors in the Replication monitor, and the entire process stops. Depending on the erro...more >>

I am looking at setting up snapshot replication in a two server environment and I don't want to purchase a third server as a distributor. The second server will be configured as a warm spare and will have very low access. The manual says that I can set up the publisher as the distributor also ...more >>

Hi everyone, I'm currently running merge replication between two sql2k (sp3) and win2k(sp4) servers. My question is with the snapshot. Other than the snapshot agent blocking users while it bulk-copies the data out, will the merge agent continue to replicate transcations that come through ...more >>

I'm running replication at my subscribe It processes all the articles o Then I get Downloaded 100 data changes (5 inserts, 95 updates, 0 deletes, 0 conflicts) Then, The process could not enumerate changes at the 'Publisher'. The step succeeded Then, The job succeeded. The Job was invoked by Us...more >>

Hi, I have a user who is trying to do manual bulk inserts from an excel file to a replicated table. The DTS package she creates is failing because of a unique key indentifier created by the push replication. Is there a way around this without having to stop replication each time? Thanks...more >>

I have a successful internet enabled (ftp & anonymous subscriptions) Merge replication topology, which works fine using the Windows Synch Mgr or EM. The problem is that I'm trying to set up the SqlMerge activeX object (on the Subscriber) to do the same. I have been partially successful...i...more >>

I'm getting an error when I try to synch to the Northwind db on my own computer via the simulator on my own computer: "Some Distributor properties are not specified. [,,,,,] I know the InternetUrl is correct because when I go there it says "SQL Server CE Server Agent" My publication snapshot f...more >>

I am getting a typical kind of problem with the replication. I have a local server and a web server. I am able to register the web server ( SQL SERVER ) on my local server. Now I am trying to replicate the data in between them. But I am not getting the success. So could I get a help in that regard, ...more >>

I have a web application that that runs with SQL 2000 as the DB. I have a backup DB server that is used for reporting and as a spare in case my primary DB server crashes. My problem is that I've tried Merge replication and transactional replication. Neither seem to work exactly like I was hop...more >>

Has anyone tried to shrink a publishing database? If so, were there any problems as far as messing up replication? Please advise... Thanks, Brett I am using SQL Server 2000 ...more >>

Hi, What is the best way to manage logins on publication server & all subscribers? Thanks -Nilay...more >>

Microsoft Customer this is the latest version of security update, the "November 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now ...more >>

Hello. When I try to create replication it fails because the snaphot can never be created because the folder is read- only. I try to remove the property read-only but it always reset itself to read-only....more >>

How do you publish Sql server in Active Directory?...more >>

Hi, All. I am using a SQL2k transaction replication. There is an error on the distributor agent: Error at parameter 12 during datastream processing of parameterized command I have never seen this error before. Could anyone help on this? Thanks....more >>

We are using transactional replication. I needed to remove replication so I used the Wizard to do so. The process is not comlete; all of the replication agents are gone, but the distribution database is still there. I had gotten an error during the removal process that the distribution databas...more >>

Don't know if anyone has received this error but when i am running the replication wizard to create a snapshot, i receive the following error: "SQL Server Enterprise Manager could not create publication 'TestData' from database 'Test'. Error 14294: Supply either @job_id or @job_name to ide...more >>

Microsoft Consumer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three new vulnerabilities. Install now to continue keepin...more >>

When I try to filter the results of an article based on another based on an initial article's FK relationship to it, I get an error that The name tbl_department_tbl_users was not found in the MergeSubsetFilters. Check the qualified name.... (???) My join looks like: SELECT <published_c...more >>

Sorry, this is kind of a newbie question, but, can someone explain to me why I have a consultant telling me a database *must* be in "read only" mode for replication to take place. I can understand the keeping connections down when the scripts are running, but essentially this leaves us with only...more >>

Anyone can tell me the different between transactional replication and merge replication? Thank you ...more >>

I have added a number of stored procedures as articles to a Transactional Publication. I thought that changes that I made to the source code of these stored procs would be replicated to the other servers, but this is not happening. All the data in the table articles is replicating just f...more >>

Hi, I am new to Sql Server, and I'm helping out on a replication project that uses 2000 Standard ed. I was wondering if I can find answers to some of our questions: -How can replication be used to create a fail over server. -Will the server fail over automatically or will it have to ...more >>

I have a Windows 2000 Server and SQL Server 2000 (SERVER1), both with the last updates available from windowsupdate. This server is located at the central office, we have a low speed conection with another office, and I am configuring a local server for them. This server is a Windows 2000 Server...more >>

Hi All, Sorry guys for asking you this stupid question. I tried to setup replication between two SQL Servers. I setup a snapshot replication, no immediate update, push replication, scheduled to be run every 5 minutes. I have followed instructions on MS SQL Books Online but I've got problem...more >>

I have a strange problem. I was switching replication from one distributor to another (Merge) I had an assistant helping for training purposes. After removing subscribers and publications from my old server I realized that two of my remote servers have a couple of tables that are still mar...more >>

Does MSDE support merge replication ?? TIA Daniel ...more >>

I have this error when i try to connect to the publicator "The process could not connect to distribuitor'Server1' Login failed for user" What i need to do for resolve this??? Thanks In advance Alejandro ...more >>

how to create a new field --> u_id ( number,identity[1,1] ) or modify existing field --> username (nvarchar,20) to change username (nvarchar,50) try to create or modify filed i have error message ("unable to modify table. .....because it is being used for replication.") thanx all... ...more >>

Hi all: I have setup a warm standby database environment. We wanted to use the standby db as a backup of the primary as well as a reporting database for our web applications. The web apps worked fine except during the time when logs were shipped from the primary db to the standby db, whic...more >>

Environment is: SQL Server 2000 SP3 (8.00.760) Replication topology: MSDE 2000 SP3 Subscribers using anonymous pull subscription I seem to be having a problem with security on the folder that contains my compressed snapshot (snapshot.cab). The share is configured so that Everyone has full ac...more >>

Microsoft Client this is the latest version of security update, the "November 2003, 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 help...more >>

Hi I am running Merge Replication, using Named Pull subscriptions over FTP between our clients and a central server. This process works fine as long as small amounts of data change between all databases (Les than 1000 changes between merges). The problem is that I have 38000 data changes that...more >>

Hi, I am using merge replication for data sync. My objective is to transfer updates from subscriber (pull subscription) to publisher. I am making use of property 'Exchange_Type' of replication object. However, upon execution, the code does not uploads the changes, although it doesnt give any error....more >>

While initializing a new subscriber with a concurrent snapshot publication, we ran into error "'Could not locate text information records for column # during command construction". It seemed to happen after we had ran snapshot for the article and once an update or insert hit the table. It also seeme...more >>

Hi, How to insert a new colum to a table article without stopping the Merge Replication. Using sp_repladdcolumn we can append a column to the tale at the end. But we need to insert a new column in between. How to do that? Thanks, San N ...more >>