Replication

Which account on SQL 2005 web sync via https
Hi, environment is SQL2005 [wkg_sql] non domain & IIS6 [wkg_iis] non domain. My steps are same as the steps in the following three articles: How to: Configure a Publication to Allow for Web Synchronization (SQL Server Management Studio) http://technet.microsoft.com/en-us/library/ms345211(SQL.90).aspx How to: ... 28 Jul 2008 11:01

Error 20026. The Publication does not exist.
I restored the database in question and did not use the 'retain replication settings' on the restore panel. I refreshed the publications, and the replications references were gone!!! I did not find any reference to the publications in any of the distibution databases. Restore the database without the replication settin... 23 Jul 2008 10:12

Merge Replication Error
Hello NG, we encounter (not always but in 0,5% of all cases) the following phenomenon in a merge replication environment. The following states of a datarow can be observed on the publisher 1) State A (Creation of the rowdata on the publisher) --> sent to subscribers via replication 2) State A->B after rep... 23 Jul 2008 08:09

Merge Replication problem
I have created a publisher on one SQL Server 2000 box for a merge replication. When I create the subscription, I receive the following error: Message The schema script '\\NVIS\$SQLDATA$xxxxxxx_1.sch' could not be propagated to the subscriber. The step failed. I been looking everywhere for an answer but ha... 25 Jul 2008 05:18

Web Replication Problem
Hello again, and tg such a place exists. I have a single publisher SQL2005 Standard to SQL Express one to many replication topology for established customer info solution that using SMO and ActiveX in CLR. The code is largely inspired by the AdventureWorks sample. Replication flavour is subscriber pull using ... 22 Jul 2008 07:32

How Sql 2005 to cleanup replication inherited from Sql 2000 migrated table?
Hi all, I'm trying to modify a table in SQL Server 2005 but I get the following error: Cannot drop the table 'dbo.aArtiEmp' because it is being used for replication But this table IS NOT participating on any replication. Actually replication is not configured at all in the server. It is the short history. ... 21 Jul 2008 22:20

Transactional replications - Distribution agents limit
Hello, I have 212 publications for push transactional replications on SQL Server 2005 Ent SP2 + WinSrv2003. 190 of them between 2 servers. And I have issue with Distribution Agents. LogReader agents are working properly. All publications synchronized. When Distribution Agents are starting they reach limit in 12... 22 Jul 2008 06:30

Understanding Latency
Greetings, I have recently started working in an environment that uses replication extensively. As part of that there are times where we are seeing some high latency times. I am wondering if there are some key queries that I can use to get some detailed information about what commands are causing the lag, is ... 22 Jul 2008 06:30

New publication wizard ends with error
Hi I installed a new instance of sql server 2005 developer, installed sp2 on top and restored a previously backed up sql server 2005 database. I then went on to setup merge replication. I ran the 'Configure Distributor' step with success. When I tried to create a new publication by right clicking on 'Local ... 22 Jul 2008 06:30

SQL Server merge replication questions
Hi Merge replication between SQL Server 2000 publisher and SQL Server 2005 Express subscribers. I have the following questions; 1. My tables have int increment primary keys. Do I need anything special for replication to handle PK conflicts between copies of database or is it done automatically? 2. Will a... 22 Jul 2008 06:30