Why would a replication Push go into a status of "Running" and Last = Action "Delivering Replicated Transactions", and yet just seem to be = hung up there & not finishing. This publication/subscription was running fine for months & now all of a = sudden seems to be hanging. The Log reader says ...more >>

Newbie - Mission-critical SQL2000 DB that is accessed by a front-end 3rd party app that is doing 99% cursor statements for data manipulation. I need an offsite replication that meets the following requirements which method is best: Transactional, merge, snapshot? requirments: - DB must be ...more >>

Hi all, I am running SQL Server 2000 sp4 with remote distribution server. I have publications. When I adding new articles to the publications, the snapshot agent doesn't pick up a new articles. When running the snapshot agent, it will say snapshot was not generated because no subscription...more >>

Hi all, In a nuttshell: - SQL Server 2000 (sp4) with approx. 10 subscribers (MSDE SP4) - Merge replication, subscription expiration set to 30 days - Merge replication set to continuously - Agent (and SQL) run with a domain-account that has admin-rights on the server and on the local boxes. ...more >>

I am trying to set up interactive conflict resolution between a SQL 2005 Enterprise Edition server (publisher) and SQL 2005 Express Edition clients (subscribers). I get the following error: The merge process failed to get correct information about the Interactive Resolver component from the...more >>

Hi All, I need to trigger the SQL Server Merge Replication Programmatically from my Java based GUI. The GUI is web based using JSP, Servlets. ...more >>

Hi Can anyone tell me if the sequence of updates in transactional replication is applied in order as they are received. for example, I have 2 tables (A and B) that are being replicated to another server. If I have a stored procedure that update table A and then update table B. will that ...more >>

Hi, I have created transactional replication with 5 publisher.I want to alter a column defination of one of the article.Should I drop the publication and recreate the publication or is there an easy way out ...more >>

The client production server CPU starts thrashing. Task manager indicates that SQL server is gobbling CPU cycles. Having a look at the replication monitor, it is obvious that indivual synchronisations to the mobile devices are taking significantly longer expected. Observing an indivual sync...more >>

I am using MSSQL 2005 with Transactional Replication Is there a way to replicate Users and all the User Mapping settings? Thank you in advance. ...more >>

I'm very new on the project here. We had a transactional replication machine fail over night with the following event log message. SQLSERVERAGENT - " Microsoft SQL Server Replication : The C:_Program Files_Microsoft SQL Server_80_COM_distrib.exe executable is terminating abnormally because i...more >>

Hi everyone, We have transactional replication between a data entry and reporting servers. Now, in addition, we added another subscriber which is a test server. This new subscriber has a strange problem that stopping and starting a distribution agent can cause a subscription to be marked in...more >>

Hi All, I setup a replication from one SQL 2000 server (A) to another (B). Before creating a replication I scripted a database on a server A and ran a script (successfuly) on the server B. It created all tables, views, sps, etc. After a snapshot had been generated and synchronization be...more >>

Hi Guys, Trying to fathom out my replication issues... Got two boxes running SQL Server 2000, reporting version 8.00.2162. Trying to set up Merge replication between them, using FTP. Publisher/Distributor is Windows 2000, Subscriber is Windows 2003. SQL Server and the Agent are both runni...more >>

Dear All, I am trying to put distirbuter and subscriber on the same SQL Server Machine. I achieved to enable the remote distributer on my server 2.I was able to enable server1 as a publisher. I wanted to create my publication on my server 1 and use the server 2 as a distributer and the subscrib...more >>

Dear All, I am very new to SQL Server replication, currently I am using SQL Server 2005, could any body please inform me where can I get the step by step guidance for building a DB replication.. Please advise.. Thanks & Regards Winanjaya...more >>

When i configured snapshot replication for the database. It was done accordingly but in replication alerts i found series of alerts like: 1. agent custom shutdown 2. agent failure 3. agent retry 4. agent success 5. expired subscription dropped 6. Subscriber has failed data validat...more >>

I'm having severe troubles getting replication to work reliably from SQL Server 2000 to Oracle. I've configured the replication to work periodically rather than continuously. The basic issue is that every time the replication is activated, an attempt is made to create the table msrepl7, and sinc...more >>

...more >>

Hi , This is from BOL : where it said it can improve on the performance on Generating & Initializing snapshot How to set the – UseInprocLoader property (Enterprise Manager) On the server where the Distribution Agent or Merge Agent is running, expand the Replication Monitor node, click the...more >>

Hi, I'm running SQL Server 2005 Standard edition. In SQL Server Management Studio when I right click on replication and select New I can only create a Subscription. Why can I not create a publication? Thanks, Aidan ...more >>

We have developed a mobile system that use merge replication for SQL Mobile to SQL 2005. Previously we have developed mutliple mobile systems using merge replication for SQL Ce to SQL 2000. Based on the knowledge we had gathered over about 4 years, we applied the synchronisation parameters ...more >>

Hi there, We are currently reviewing upgrading our Transactional Replication from SQL 2000 to SQL 2005. Out test environment consists on SQL 2000 Publisher, SQL2005 Distributor, SQL 2000 Subscriber, and a SQL 2005 Subscriber across 4 different servers. We successfully configured a transact...more >>

Hi: I want to add an article to existing publication using Transactional Replication. If I run the snapshot agent, will it run just for that article or for all the articles in the publication. I only want to run for article because other articles are huge and it will create performance pr...more >>

I know that I should just try this, but I thought I'd ask anyway. I set up db mirroring between 2, 2k5 servers. The mirror dbs are in a (Mirror, Syncronized, Restoring...) state. If I had restored the dbs on the Mirror server using STANDBY, would the database be accessable in read-only mode ...more >>

Hi All, I setup a transation replication. Everything seemed to go very smoothly when I set it up. When my snapshot ran it failed due to this error: "The process could not create file '\\RP3\MSSQL\MSSQL\REPLDATA\unc'." Access denied. can someone tell me what account runs the Repl agent and ...more >>

Hi, What are all those procedure ending with _pal? sp_sel_FBB67B0A93364BEDE88DF94B39ED4222_pal Is that come from a replication? I use to have a replication on that database and I drop the replication Does those procedures should be deleted If Yes can I just deleted One by One or Is th...more >>

Hi, I'm in the midst of performing a replication on SQL 2005, however i'm not too sure how CPU intensive is the replication service. Does anyone know whether do 2 CPU enuf for replication purposes....more >>

i want to write an application to collect information about how many transactions does not currently not replicated to subscriber at the time of call. where and how can i find these information ?...more >>

Hi, I have setup replication but it's not very stable i.e sometimes the connection is bad, in this case will using bcp & bulk insert help to allow me to transfer the data faster ? i have tried to use the following commands : bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_...more >>

Simply a curiousity thing, as it seems somewhat a pointless setting, so I'm wondering if anyone knows why the default Identity ranges are set at 100? I cannot envision a scenario in the real world where 100 would do anything but create more problems down the road. ...more >>

Dear all, I would like to replicate the data from HQ to the other region. This region only have dial up access to the internet. In order to make the 2 database between HQ and other region syhcronized, i am thinking about using database replication of sql server. Few questions i would like to ...more >>

Hello, In SQL Server 2000, there is an option to not lock the tables (articles) contained in a publication when a snapshot is taken. I do not see the option to set this in SQL Server 2005. Does it automatically not lock the tables when taking the snapshot? Or am I just not finding where to...more >>

Hi, In SQL 2000, if the replication is down, how can I have it automatically backup? There is going to have a long down time if the operation can't reach the server right away. Any help will be appreciated. Thanks in advance! Lisa...more >>

I will be snapshotting quite a few million rows (100 million + ) and want to get it completed fast. Will be using transactional replication Where can I specify the -UseInprocLoader and-MaxBCPThreads settings for the snapshot and distrib agent ? What parameters should I provide ? I have a 4...more >>

Bonjour, J'ai un développement à réaliser qui comporte une saisie déportée sur des sites distants. Les données doivent être mémorisées sur le poste de travail de l'utilisateur. Une ligne VPN sera installée entre les différents sites et un serveur centralisé au siège. Si la liaiso...more >>

SQL 2000 sp4 on publisher and subscriber The publication is a filtered merge, publication has been working fine, replaced subscriber box with new blade server - same pc name/same ip/same sql name, SQL 2000 sp4. 3 replicated databases - 1 small merge, 1 small transactional, 1 large merge I set...more >>

Acording SQL Server 2005 Books Online: http://msdn2.microsoft.com/en-us/library/ms173543.aspx [...]If your application has immediate-updating Subscribers, sp_publication_validation may detect spurious errors.[...] We are using transactional replication with queued updates on SQL Server 200...more >>

Hello, I'm trying to install a transaction replication and get this error by start of the snapshot-agent: 1224 The requested operation cannot be performed on a file with a user-mapped section open. Both servers are sql2000 with SP4. A test-replication with northwind works. The proce...more >>

Hi, Anyone knows which editions of SQL 2005 support peer-to-peer replication? Thanks in advance ...more >>

Hi , My snapshot agent was suddenly showing the above message and when i tried to look into the agent's history it did not show me any error details . i simply right-click the snapshot agent and --> start agent and the error disappears but what cause that error ? appreciate ur advise...more >>

Hello, Being a bit of a SQL Server novice, need some advice with the following situation. Server A and Server B have SQLServer 2000 based databases. The vendor of the application/system has implemented their own replication process to ensure the 2 databases are in sync. However, there is no...more >>

I have replication setup between server A & B, both SQL 2005. Server A is distributor/publisher & B is subscriber. I have has merge replication working for 10 databases for awhile now. Each database has only one merge publication and one subscription each. Symptoms: Publications starting s...more >>

Hi, Why the replication could not create this new column. The replication have 5 new column to create on the subcriber He create the first 3 columns and at the fourth one I receive this message The schema script 'exec sp_repladdcolumn '[dbo].[temps]','HeuresRNC',' float NOT NULL DEFAU...more >>

Hi, My SQL server is version 2000. I am trying to get email alert when any of my distribution agents is down. I have set up Outlook XP and able to send/receive email. I have set up SQL mail to use that profile. In Replication alert, I enabled agent fail, but I still fail to receive alert ...more >>

I am having a problem with getting merge replication to work between a SQL 2005 Publication and a SQL Express subscriber using RMO in a C# windows app. Everything I have read indicates that you can use a MergePullSubscription object, set the values for DatabaseName, PublisherName, PublicationNa...more >>

Hi, i am new to this so really need some helpfull and easy to follow information so that i can successfully replicate my SQL Server Database. Here is my dilema. I have a working SQL Server 2000 Database which has an IP address and alias so can be connected to by the outside world. However on ...more >>

I'm trying to set up a new publication for a database. However, everytime I try it the snapshot agent hangs while trying to bulkcopy the contents of a particular table. I've tried running dbcc checkdb, and dbcc checktable but everything seems to be okay. Can anyone point me in the right d...more >>

In SQL 2005, how do you look at, and ultimately update, system tables such as a MSmerge_conflict_publication_article table? I can't find an INFORMATION_SCHEMA view that allows this. Currently in SQL 2000, I will periodically purge the conflicts that have been recorded in these type of t...more >>

hi, I have been tasked with restructuring a database. The database is currently recreated for different periods so for 2005/2006 we have one database and for 2006/2007 we have another. But clearly some tables do not change much and so they want these tables hived off to a separately maintaina...more >>