I want to drop a table from some of my transactional publications. Can I just drop the article on the publisher and then be able to delete the table at the subscriber? Or do I have to drop the article and re-snapshot the subscriber?...more >>

I am using the SQL Server Personal edition in remote offices with 2 or 3 clients each to connect to our central office server running SQL Server Standard Edition. I want to use the personal edition because when I am using replication between each client and main office and the EM will be use...more >>

From the looks of other messages, I'm in the right place. I have a question about the replication services in SQK2k. I work in a Realty Estate management company where we use a management tool connected to a SQL2k DB. I'm in the process of planning a move of our data to a third party manage...more >>

Setup: - SQL2000 SP3 running on Windows2000 servers. I have a merge replication running between three identical servers. Two of the servers, the publisher and subscriber1, receive data from different sources and are synced every day at 4am. Subscriber2 is a query server only and is upd...more >>

I would like to have a backup server ready to take over just in case I experience an issue with one my SQL servers. The idea is that if one server goes down, the other one is working in the background and is seemless to the end user. I have the NLB manager running with 2 ip address linking ...more >>

Greetings, We are using SQLServer 2000 and we are replicating one server to another using merge replication... It has been working fine but all of the sudden, we are getting "An exception occurred in the Snapshot subsystem"... I've tried re-creating the publication a number of times but alwa...more >>

Hi I am going to use the basic code in the vb.net sample in Hilarys Cotter book. to set up subscribers. Only thing that puzzles me, is that each client probably will have different names. I tried to different types of names in the strSubscriber like: strSubscriber="(Local)" strSubscriber="<...more >>

Hey guys, Thanks so much for this great newsgroup btw, helped me hugely through doing replication via handheld units etc. I'm running into a bit of a problem between server 2 server replication. Both databases have user defined data types. All the tables using them are fine, but once the...more >>

I have setup transactional replication between two servers and it is working just fine. When I perform alter table and add column it works just fine but when I alter table and disable trigeer it doesnt let me do saying table is been used by replication. Any advise......more >>

I've searched the forum as well as the books I have but haven't found an answer to this. I have a table that needs to be replicated to other databases on the same server. The subscribing databases has tables that needs to keep relationships to certain data in the replicated table. That ...more >>

Hello: I'd like to migrate an in production merge repl topology to a new server: here's my plan (in a lab first) 1. turn off the vpn (subs simply can't connect & sync) 2. install the new server (create matching the ip & servername) install sql & match sp levels (builds) of orig ser...more >>

Upon creating a new Pull Subscription on a Subscriber, I kept on getting the error message "SQL Server enterprise Manager could not create a pull subscription to publication 'XXXX' Error 14234: The specified '@server' is invalid(valid values are returned by sp_helpserver). Where did I go wrong ...more >>

Hi, In windows 2003 server you have NLB (Network Load Balancing). Can i use this to load balance my traffic to our sql server? I know you also have "Microsoft Cluster Service" but that's only available with Windows Server 2003 Enterprise Edition. So is it possible to load balance my traf...more >>

Hi, we have a central sql server and we want to distribute data across our regional offices. We've tried the following topology Server A ---- transactional replication --> Server B --Merge Replication with filters------> server C server A = central database server B = republisher se...more >>

After executing sp_addscriptexec (which returned without errors) when I try to replicate, I get the error ' 0\\SHARE\...\Users.sql could not be propagated to the subscriber' Any ideas what may be causing this please? -- Michael Tissington http://www.oaklodge.com http://www.tabtag.com ...more >>

Is this a good performance increase suggestion if disk I/O seems to be an issue sometimes. We are replicating some very busy tables across a wan. We have ram to spare on our distributor. We thought about pinning the ms_replcommands table to see if we could help disk i/o . is this a g...more >>

I currently have a two SQL Servers in a Windows 2003 Cluster with the database sitting on a directly attached fiber channel storage array (EMC CX300). I have another SQL Server (Standalone) in a remote location that is going to be used for disaster recovery. The cluster and the standalone ...more >>

Got a weird one. Hope someone has seen it before. Need some smarts. Rolled out 150 new laptops, all imaged the same for users with a local msde sp3a. All installed with subscriptionDB. Previously, all were synching well on the same Sql 2000 pub/distr, on the same publications for 18 mont...more >>

I am having many problems implementing Merge Replication. Current setup: Main SQL server ~ AA Local MSDE ~ BB Local MSDE ~ CC When I setup BB to merge with AA, everything works fine. When I setup CC to also merge with AA, the triggers get all mixed up. Some will be delete from AA. Al...more >>

I have setup up transactional replication for few tables only from Server A(publisher) to Server B(subscriber) with out taking snapshot and by using backup. Transactions are replicated fine. 1. My question is during my testing I had executed a stored procedure that has disable trigger st...more >>

Hello all, I have a server that was named "AlienDB" running SQL Server. I renamed the server to "StagingAlienDB1" and now I am having problems configuring replication. When I try to do anything such as create a new Publication, SQL Server immediately shows me a message box containing the...more >>

I am unclear on the best way to handle the following situation: I am going to be pushing a merge subscription from ServerA to ServerB. ServerB already has all of the objects that are articles in the subscription, but the data in the tables is out of date and needs to be synchronized when the s...more >>

Ok let me explain my problem I update table abc to SERVER A SERVER A push a replication to SERVER B and SERVER B push to SERVER A and SERVER C SERVER A and C are configure to replicate to SERVER B and SERVER B is configure to replicate to SERVER A and SERVER C (same tables are replicate) ...more >>

I am trying to use triggers (UPDATE, DELETE, INSERT) on replicated table on subscriber. I use transactional replication and it is configured to replace: INSERT with CALL sp_MSins_Facility UPDATE with MCALL sp_MSupd_Facility DELETE with CALL sp_MSdel_Facility When I execute INSERT or DELET...more >>

Hi all, My sql2000 to sql2000 merge replication via internet is run via an application on the subscriber using activex library. I read about setting up pass-through authentication so that the user accounts don't need to be on the same domain. So, I set up Sql Server and Sql Agent to run on ...more >>

I have a shared folder on my c drive called Snapshot. When using the publication wizard I get a "not a valid path error" if I manually type in the path or browse to it. I am running Windows XP Pro, I have disabled simple sharing and allowed everyone full control. The folder is marked as read o...more >>

Someone posted the question "Can anyone point me towards a source code listing for a working replication custom resolver written in .Net?" Here is an example that I have written. Custom resolvers are created by adding a reference to the Microsoft SQL Replication Conflict Resolver Library, ...more >>

Hi all, I'm setting up merge replication. I am publishing a set of tables that is about 6gb in size, no filtering. The snapshot is set to be done in character mode (needs to be), compressed (tried uncompressed too). One of the tables contains binary data. When the initial snapshot agent run...more >>

SQL Server 2000 sp4 Could you feed me about replication problem when using begin transaction and commit transaction command ??? ...more >>

Hi We have a Win 2000 SQL server - running sp3 - it is acting as publisher/distributor. It has about 40 databases with each having one or two anonymous merge subscribers. Any advice / recommendations / tales of caution with regarding to upgrading the publisher/distributor and the subs...more >>

I want to bulk copy a table into a text file at SQL Server 6.5, There are some columes with "datetime" type. When bcp finished, I find the value of the columes with "datetime" type lost the second in text file. How can I do?...more >>

I have a server with around 50 dbs. I would like to find out, if any of the databases are subscribing dbs from other publishers. I know to find published dbs by seeing the hand icon on the database name in Enterprise Manager, but not sure how to find out for subscribing dbs Thanks ...more >>

Hi, I am dealing with merge replication between local & remote servers. Last week the following error occurs two times. The merge process could not perform retention-based meta data cleanup in database 'TEST'. (Source: Merge Replication Provider (Agent); Error number: -2147199467) ...more >>

I was disabling publication and distribution through enterprise manager but the process could not complete due a file access problem in the REPLDATA folder. The net result is that although it looks like the publication on the server was dropped, it keeps showing up in various places. For examp...more >>

I'm running a SQL 7 db on a LAN in city A with other users accessing it from another city (city B) over a WAN. Obviously the WAN users are getting much slower access to the data. One thing I was wondering was if it was possible to have two versions of the database, one on each server, and have...more >>

We are planning on using our secondary database as a reporting server with log shipping. The problem is that log shipping puts the db in read only mode and occasionally we need to add user permissions to the secondary only. The only option I see is everytime permissions are needed we would hav...more >>

It seems that when the replication monitor loses contact with a pull distribution agent on separate server for a prolonged period of time, the replication monitor for the agent shows RETRY. But then stays in retry even when the actual distribution agent has failed (this is due to competing proce...more >>

I am using Transactional replication and from time to time I get an Invalid column error on the distribution agent for either a stored procedure or view. When I take a look at the table definition script I see that it is missing the newest columns that were added. Does anyone else have this ...more >>

I have just set up a merge publication of an entire database. After the merge agent ran for the first time and the snapshot was applied I ran it again just to see it say "No data needed to be merged". I was surprised to see 34 updates and 1 insert being downloaded from the subscriber. I ran th...more >>

Hi All, Is it possible or okay for setting the publishing DB in a merge replication setup to Simple recovery model instead of the current Bulk-logged model? Will this have an impact to the subscribers? Thanks. Aramid...more >>

Hi everyone, I would like to know if there is some way to add a new column to an existing table in a database published via merge replication that does not require reinitialization of the articles. Thanks. Aramid...more >>