any tools or advice on moving dbs from sql2000 server in one domain to a new domain with sql2000??...more >>

i just want to use Transact-SQL or System Stored Procedures or something like that to implement the replication , but i find the system stored procedures are too many and make me puzzle,can any one give a help to me?...more >>

I have a SQL 2000 running merge replication to Pocket PC devices. All works well there. I have now added a SSL 128-bit certificate to my IIS 6 server. It is working over the network to my Pocket PC device from IE. The browser does bring up a dialog each time I access the site which states (...more >>

I am attempting to use the CDW, to copy a database on my laptop running SQL server 2000 PE to a server running SQL Server 2000 standard edition. I think that I have set all of the appropriate permissions/authentications etc. I have run it both from EM and the command line but it fails to...more >>

I am receiving these errors, does anyone know why they are occuring and how to resolve them? The process could not execute 'sp_repldone/sp_replcounters Thanks, niv ...more >>

Running Win 2000 & SQL 2000 I have a merge publication/subscription (rows are filtered by location), replicating data between 16 servers (15 remote location & a main office). When data is changed at the a remote location, the changes gets propagated to the main office, but at some point,...more >>

Hello NG, i need your help please for 2 Replikation Problems. We have a Mergereplikation on SQL Server 2000 (SP 4) The subscriber is connected to your company Intranet over I added a new Publication and Abonoment for testing. I remove them at the Enterprise Manager with the delete Pro...more >>

Oracle has a neat concept called multimaster replication where you are able to update your data in multiple locations. Is it possible to implement this with SQL server? I have tried "transactional replication with updatable subscribers" but the performance at the subscribers wasn't good e...more >>

Hello NG, i need your help please for 2 other Replikation Problems. We have a Mergereplikation on SQL Server 2000 (SP 4) The subscriber is connected to your company Intranet over ISDN Line. We copie the Snapshotfile to the destenation folder of the subsriber. The Mergeagent start to extr...more >>

i have a db on sql server that people in the office connect to using an .ad i would like staff who have company laptops to take away a copy of this db wor offline, then when they are next in the office sync with the main sql server db i have read about using (central publication model/merge repl...more >>

Hello, The replication agent has failed and returns the error below. The log file for database 'Orders' is full. Back up the transaction log for the database to free up some log space. I am in the process of backing up the transaction log with the truncate only option. Questions: (1)...more >>

Hi, I am trying to synchronize data between a publisher running in SQL Server 2000 enterprise edition and a subscriber running in MSDE 2000 using DMO with Merge ActiveX component. My program is in VB.NET. Now, everytime I try to synchronize data, the changes at subscriber don't get reflected at p...more >>

Hi I have added an oracle linked server as a subscriber, when I create a push publication, I can not see the oracle linked server as an enabled subscriber under the enabled subscriber list in the 'Push Publication' wizard. Is this something I need to worry or this is just how linked Oracle server ...more >>

Hi, we are having a merge replication of 2 DB 2000. I changed the store place of the snapshot from the local publisher to the subcriber that is connect with DSL/ISDN Phonline. It takes 12 hours to transmit the compressed snapshot then it crashed. But i transmitt a old but good snapshot to the ...more >>

Need to be able to add data to a mobile with SQL2K desktop edition and then manually replicate to SQL2K on server. Can't access the distribution server from the mobile. Thoughts suggestions etc? thanks...more >>

I have different heterogeneous databases (SQL Server as well as Oracle) which need to transfer their data to a central SQL Server database for reporting purposes. Central location needs to be kept up-to-date on a periodic basis, say every night we consolidate data from different sources. There can b...more >>

Hi all, I have a following problem with my replication. I have 3 machines - 1 is publisher and its own distributor, and two are subscribers. The replication topology model is "central publisher". The problem concerns the merge replication with filtering (filter is "2=1"). This replication s...more >>

Paul, I have recreated the subscription database as per your advice, and now the distribution agent seems to succeed. However I am having problems with the snapshot agent. I have tried to make a printscreen capture of the various windows and will be sending it to you. Could you kindly t...more >>

I need to schedule a snapshot replication of some tables and a merge replication of a couple other tables. I would like to know the best way to schedule the various replication agents. My questions are: - Should I arrange the schedule in this order: Step 1. Run Snapshot Agent for sna...more >>

H I noticed that my transactional repl is working slower when on the other side MSdistribution_history and MSrepl_commands tabel geting biger and biger. Replications still works OK, but anyway slower. Cleaning agents work OK, there are no errors, so I dont understand why MSdistribution_history tab...more >>

Hi all We are preparing to upgrade from SQL 7 to SQL 2000 and we have transactional replication running from this server to Sybase 12.5. We also have couple of batch jobs puling data from Sybase and Oracle to this SQL & server. I'd like to here your experience about moving from SQL7 to SQL2000, es...more >>

Hi all OS: Windows 2003 Serve SQL: SQL Server Developer 200 I was searching the forums and the web but didn't find any information on solving this problem On the publisher when I look at the Replication Monitor -> Merge Agents section I see the following error . I've tried to removing and rec...more >>

Hi We are running SQL Server 2000 on a Windows 2003 Server. The Windows 2003 Server is connected to a RAID disk array. The Windows 2003 server is a single point of failure. We want to add a second Windows 2003 box and connect it to the RAID as a backup node. It seems there are two ways to do th...more >>

Windows 2000(SP4)+SQL Server 2000(SP3)+ServerU FTP I created a publisher and distribuer on my first server using ftp. Then I create the pullsubscriber use store procedure sp_addpullsubscription and sp_addpullsubscription_agent, I had set use_ftp equal true, but the subscriber always report tha...more >>

Hello, NG, I installed a - w2k server with sp4 - no active directory - sql server 2000 - sql server sp3a I configured a merge replication. The snapshot agent does not work. Manually starting the snapshot agent: (Error code in German, here translated roughly): Error 22022: SQL Server Agent...more >>

Hello, I would like to start a merge agent from a stored procedure. Does anyone know how to do this.. Thanks, niv...more >>

Hi - I'm trying to set up merge replication between a SQLCE database on a Windows Mobile PDA and a SQL2K database on the desktop. I can do this using Enterprise Manager, but I need to do this programmatically (in my VB.NET program) instead. I'm using SQL-DMO, and I'm running into an error th...more >>

Hi there, I have converted MS access database to sql 2000 database and front end is in adp. i our db all of our table contain identity field as a primary key and forgine key. I am using merge replication with the publisher and distributer in the same server where original db is and may have m...more >>

Hello, We have SQL Server 2000 standard running on our production box and the database is about 40gigs , I would like to set up a snapshot replication , My concern or qs is that can i set up snapshot replication to run more than once a day and in case of a failure of the production server...more >>

Dear all I'm just trying to do merge replication between to DB with Dialup connection - If any conflict occur, does the default resolver let the publisher win? or should we use another resolver? how - What will happen if the connection totally broken during running synchronization Thanks in adva...more >>

Hi Pulling my hair out trying to find a resolution to the following problem. Any help would be greatly appreciated. Windows 2000 OS SP4, SQL Server 2000 SP3 replicating using transactional replication from one server (lets call this server 1) inside our network out to the internet to anothe...more >>

Hi all, I have something very strange. In moment of runing snapshot agent for marge replication I am receiving an error: "Line 1: Incorrect syntax near 'H'.". Last succided action of the aggent is generating trigger script for an article - the last one from my article list. Compering other rep...more >>

Hi I have not had much luck setting this up. Here is my situation. I have 3 stores which have inventory. Each store updates their own inventory every few hours. I want all stores to be able to see inventory from all stores. I want this to be as close to real time as possible. I ...more >>

My company supports sales people with handheld devices used to track and create orders. They are generally offline and have a client-side copy of sql server on their machines. Currently, we are using merge replication and they log in each night to update our corporate servers and downloa...more >>

Hi, I have just set up a replication between 2 servers but I'd like to replicate new inserted rows ONLY i.e. no action on update and delete. So when existing records are updated / deleted at the publisher these rows should be left untouched at the subscribers. Does anyone know how to d...more >>