Hi, I've systems with merge replication setup. On publisher i 've duplicate sa and distributor_admin login names in sysxlogins. Can i delete them ? why are there duplicate login names? Regds, amit ...more >>

We are using SQL 2K with sp4 and using push replication. if I set up the push replication for the very first time, is there a way to save the time for the initial snapshot generation of all tables by having the subcriber database popuated with tables using backup and restore method from the...more >>

I Configured WebSync through SQL Server 2005 on a Windows 2003 Standard Server. IIS,CA and Application Pool are also configured. When I try to browse https://Localhost/SalesOrders/Replisapi.dll it gives me a message "The page cannot be displayed". Any help would be greatly appreciated. ...more >>

Running Win 2k & SQL 2k Is there any way to control the size of the SQL Server Log?? I have some that are in excess of 35 meg. I am not talking about the TLogs now, the SQL Server Logs. AHIA, Larry.... ...more >>

Running Win 2k & SQL 2k I am not sure if this is a bug or by design, but in my Database Maintenance Plans, on the Transaction Log Backup tab, I have the 'remove files older than:' checked, with a value of 2 weeks, but my TLogs do not delete automatically. Is this by design or a bug?? ...more >>

Hi All, I would be grateful if you can give me any direction. Case: when we do log shipping to secondary server, DB on secondary server is state read only, can read only DB replicate data to other server? The purpose of this testing is that we are trying to figure which is the best way t...more >>

We have had a server in LocationA for quite some time. The need arose recently to have a server setup in LocationB due to some bandwidth issues. LocationB was given a snapshot of the DB @ LocationA when it was first setup. However, both machines will need to have the same data as both are ...more >>

Hi, I would like to know if we can check merge replication conflicts programmatically. which tables do we need to check for replication conflicts? By default some conflict_* tables are created. will these contain the info? Rgds, amit ...more >>

Hello, I have a problem where old snapshots are not being deleted after new ones are created. I am running merge replication between two sql servers for multiple publications on multiple databases. Both servers are running sql server 2000 sp4 on windows 2000 sp4 with all updates installe...more >>

We have a 500 GB database that we are looking in to replicating. Initializing the subscriber is obviously an issue with that much data. I have read about initializing the subscriber using a backup and restore but we are also looking at a feature of our SAN (a Dell CX-500) that can create snapsho...more >>

Don't know why this job failed since I deleted and rebuilt the subscriber and publisher last week. Can someone help? Error detail says: 'Executed as user: FOSTER\sqlservice. Could not find stored procedure ''. [SQLSTATE 42000] (Error 2812) Associated statement is not prepared [SQLSTATE HY...more >>

If the publisher database is set on simple recovery mode and if the transaction log gets truncated on check point, then is there a chance that the rows that should be replicated might get lost before the log reader agent can read them and send them to the distributor. Publisher is a 7.0 box an...more >>

Hello, I had a merge replication that was replicating a table, and i deleted it, now it doesn't let me drop that replicated table in my subscriber database. It says that it is being used for replication. I even stoped and started my server, but no success. Any help !!!!!!!! Thanks, Ma...more >>

I'm synchronizing SQL Mobile 2005 with SQL Server 2005 using Merge Replication. I've filtered a table like this: WHERE HOST_NAME() = convert(nvarchar(100), patientId) "patientId" is uniqueidentifier type column, the primary key of "Patient" table. The error when synchronizing is the follo...more >>

Hi, Is it true that BDE encounters problem when the database is used for replication? We have problem with BDE when the tables are used in publication and rowguid column is added to them. The error message returned by BDE is not helpful at all (Capability is not supported!) Any help would be...more >>

Hi, I found deadlock error a week ago, and set up the 1024 traceflag as you advised. It caught one deadlock, but I'm really confused. The two nodes of the deadlock are: sp_MSmakegeneration and one stored procedure which find a specific record by key a...more >>

What are the cons of have the distribution database on its own seperate server from the publishers with regards to transactional replication ? I am more concerned from a latency perspective ? Would the changes be a bit slower to propagate to the subscriber as a result of this ? Let me kn...more >>

Hi, I intend to set up data validation and re-initialize on merge agent. But I'm not sure if it will cause data lost at subscriber side. If the data validation fail, the merge agent is supposed to re-initialize the subscriber from last successful data validation. Does it mean any data ...more >>

Hello, I have a Merge Replication, which has only one of my tables of my database. I transfer the other tables by my other replication which is transactional. This table has almost 1,300,000 records. After the snapshot is ready and it goes on to transfer the data everything goes well up to ...more >>

Hello Everyone I've been having problems getting replication up and running on our production server. Both publisher and subscriber are sitting on the same box. The issue I am having is that the Distribution agent keeps rolling back after it has deployed the initial snapshot and deployed so...more >>

Hi- I am having problems getting a transactional publication snapshot to complete on a Win2K, SQL 2K box with SP3 installed. The snapshot process runs fine through a number of tables, then disconnects from the publisher server with no error message shown. I tried dropping the article it ...more >>

Hi , I have set up my subscription to be immediate updating which has led the application program not able to bulk copy for table that has been subscripted for immediate updating so how can i remove it ? appreciate ur advise tks & rdgs -- Message posted via SQLMonster.com http://ww...more >>

It's possible in a merge replication topology to deny subscribers updates ? Thx, Ruy ...more >>

Hi, We need to setup merge replication between server A & B using TCP/IP. These servers are behind a firewall. The connection between these servers can be done only using IP (class C) How to configure this. rgds, Soura...more >>

Hi , I used sp_helpsubscription on a db and the value in the column "update mode" returned is 2 which i cannot find from SQL BOL. What does actually 2 stands for ? in BOL it states that 0 - readonly 1 - immediate-updating appreciate ur advice tk...more >>

Hi, can you setup transactional replication and log shipping on the same database? My guess is no, but would like confirmation. thanks in advance. ..chris. ...more >>

Hi Guys - I have been using the Merge Control ActiveX successfully for some time. However, one client has found a problem synchronizing. Here is the relavent piece of code: agent.Publisher = "MyServer\InstanceName"; agent.Distributor = agent.Publisher; ...more >>

Something is wrong with my distribtion database. When the distribution clean up agent runs (or I run dbo.sp_MSdistribution_cleanup manually) I get the following error message: Executed as user: sa. Table error: Database ID 9, object ID 5575058, index ID 1. Chain linkage mismatch. (1:89299)->ne...more >>

I have a question that google seems eerily quite on. I'm running SQL 2005 and am replicating (merge via the web) from an intermediate box which is also running 05. The intermediate box is replicating in some fashion (unsure since it isn't under my control) from a SQL 2K box. My issue is that w...more >>

I am ready to split my subscriptions to one with tables and one with views and stored procs as was recommended by Paul. However, our database is used by 2 major applications which share some of the tables and views. I have 2 questions: 1. Do I need to find out the exact views and stored p...more >>

I accidently removed a publication using sp_removedbreplication before deleting it from the EM. Now when I try to delete it from the EM I get this error message "'Old_publication' was not found in the TransPublication Collection. If the name is a qualified name [] to separate various parts of ...more >>

Hi, I have a server set up for Merge replication. It is the publisher and the distributer. Has been working fine. It has two publications. I wanted the subscribers to get a new copy of the data next time they replicate, so I went to the first publication, which is stored procs and vie...more >>

Hello everyone I've generated a Snapshot which has been applied. The log reader agent is happy. But the distribution agent keeps saying The process is running and is waiting for a response from one of the backend processes. The log reader is working but it's not applying what it's reading. ...more >>

Hi, We have 50 databases in Merge Replication. We want to know the replication status (replicating or failed) using query, Any query is there to find out the status? Please advise me. Rgds, Soura...more >>

I'm converting an existing production replication process to SQL 2005 for testing. My snapshot for a merge replication is failing. Environment: Single XP server, no filters, @schema_option = 0x000000000C034DD1 I have several snapshot jobs in my process, 2 for transactional replication and...more >>

I've got this SQL2K/WIN2K setup and a database having merge replication setup. It's been running there for more than couple of years. Now due to strategic changes we don't need this replication on the database. When I tried to remove it, it started blocking normal user activity that is most...more >>

I have 1 section of a stored procedure that I would like to skip if a replication is in process but I want the rest of the procedure to be processed. There is a trigger that fires during replication and normal operation that calls a SP that does some validation. I want to skip a small portio...more >>

Is it possible to set up replication to replicate to a database that is set as read-only? I would like to have the db mirrored on another system, but i do not want users to be able to 'mangle' the mirrored data. Thanks for the help! ben...more >>

Hello I'm just starting to look at replication for a job I have and I have a question about setting up a distributor. 1. Can i have multiple distributors? 2. Is it possible to define which distributor is used for a certain publication? 3. Can i set up the distributor to also be on the su...more >>

I setup a client with merge replication, the following error was returned after working successfully for a day "The agent is suspect. No response within the last 10 minutes". Most research I found on the newsgroup is this error does not stop merge replication from working, but in my case it did...more >>

I want to remove all articles from a subcription and publication. Will these two commands do it for me? EXEC sp_dropsubscription @publication = 'EMOBILE_OLTP_OLAP', @article = 'all', @subscriber = 'all', @destination_db = 'all' EXEC sp_droparticle @publication = 'EMOBILE_OLTP_OLAP', @arti...more >>

We actuallly have en error when we try to synchronize a ppc 2003 device running an application built with CF 1.0 and Sql Ce 2.0 and a Sql 2005 server. The errror is this one : 28035 SSCE_M_FAILUREQUERYINGHEADER Internal error: HTTP header information is either corrupted or missing in t...more >>