Hi, I have MERGE setup between SERVER A (Publisher)---- SERVER B (Subscriber). in a table on SERVER A i am importing data from an excel sheet say 100 records. But these records are not reflecting on SERVER B even after merge agent runs several time. What would be be possible cause? Tha...more >>

How do I get rid of the red X's in Replication Manager? They were there when 1 synch with distributor failed, but then I fixed the problem and synched again successfully but the red X's are still there. Thanks. David ...more >>

Hi, I read that we can optimise from 10 to 15 % the performance of a replication by changing the default value of the HistoryVerboseLevel and the OutputVerboseLevel of the Agent Profiles For exemple for the Distribution Agent we have to use distrib -HistoryVerboseLevel 1 distrib -OutputV...more >>

Hi All I am using the Simple Log Shipping in the SQL resource kit. just wondering if there is any way I can compress the log during the log shipping processing? thanks Justin...more >>

I have an application with a sql backend. My company has an external database on the webbox and an internal database for inter-company use. I was given the job of replicating this database between external and internal. I have 3 sql servers; BOX1 is external box that is used to run web fro...more >>

After addition of new tables to Merge replication data validation fails if i use only row count and checksum, however if i use binary checksum and rowcount it is successful. ...more >>

I am planning to do a snapshot regularly once a month to make sure that the publshing database and subscriber database are always in sycn. Our system is 24x7 but night time and weekend are relatively quiet. Is the correct process for this is to do the 'Reinitialize All subscriptions' in Rep...more >>

We want to allow our customer base to be able to access their account information online. I want to setup a second SQL server so the customers can use this for looks up. The front end to access this info is web based. What replication method is the best one to use to update the database sa...more >>

I created transaction replication with DTS transformation. Next I want to move all data from publisher to subscriber - apply snapshot to subscriber. Subscriber have different schema but no data. How it is possible to do? I expected snapshot will use same DTS, but it not use it. Publisher DB is...more >>

I cannot get a pull subscription to work at all, push works, anyone have = any suggestions as to why? =20 I currently have 1 subscription pulling from this server, but I can't = add any new pull subscriptions, I receive an error message: From EM, on Choose Publication (Using Wizard) - Click ...more >>

Hello there I have two dababases with transactional replication So far it worked fine, until somone delete all the data at the subscriber When it happend, the replication failed on error: The row was not found at the Subscriber when applying the replicated command. Now what i need to d...more >>

We are using transaction push replication and like to shut down the subscriber server for some maintenance maybe 3~4 hours. What is the best way to shut down the replication or do I even need to worry about it? I am thinking about stopping the distribution agent or maybe logreader agent ...more >>

I had a merge replication running between a publisher/distributer and 4 subscribers. Every thing was going well until I decided to reinitialize the subscriptions, this was due to changing some stored proedures at the publisher and I wanted them to be replicated to all other subscribers. Afte...more >>

Hi, I have a table without primarykey. Will i able to replicate this table. (I will not able to create a primary key in this table) If so, how will be the conflicts be identified ? Please advise Rgds, Soura...more >>

Hi,I am building the Transactional Replication.It thro's Error Like below. The process could not bulk copy out of table '[dbo].[syncobj_0x3435344541393145]'. I/O error while writing BCP data-file Category : ODBC Source : ODBC SQL Server Driver But I have Checked the Space in Both OLT...more >>

Hello there I have two servers who needs to be updated From master to slave. For this i need to use the replication I've heared that i need Enterprise on both sides and it coast approx 19000$ Do i need them on both sides? or i can use the standart -- øåòé âåìãäîø òúéã äðãñú úåëðä ...more >>

Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards ...more >>

Hi We have an internal ms access database which we need to synchronise with our website with sql server 2005 backend which is hosted on a public host. My question is; is there a way to keep the two databases synchronised using the technologies built in sql server 2005 and/or access? We also...more >>

Hi Here's my scenario... - A central SQL Server 2000 hosting several databases for different customers (one DB per customer). - Each customer has one or more MSDE databases on their own site(s) which each pull a subscription (one publication per customer) from the central SQL Serv...more >>

Agent message code 20046. Syntax error or access violation [12/23/2005 6:31:35 AM]PUBLISHER.distribution: {call sp_MSadd_distribution_history(1, 6, ?, ?, 0, 0, 0.00, 0x01, 1, ?, 1, 0x01, 0x01)} Adding alert to msdb..sysreplicationalerts: ErrorId = 393, Transaction Seqno = 000011040000a813000600...more >>

Win 2k & SQL 2k SP3a This error appears in my Application Log. How can I fix/remove/delete this? How can I determine what dB this is from?? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17052 Date: 12/23/...more >>

A command like this makes an error: select {b '21ff70e4ebd49343a01df967f20e4081'} I do not know why publisher has generated this, and why susbcriptor do not understand it. the error is the following: [Microsoft][ODBC SQL Server Driver]Syntax error or access violation Can anybody help m...more >>

What is the easy command (if any) to see if the server is a publisher or a subscriber in a replication environment? Darin *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have an anynonomous pull merge set and working. But, I create a new table on the client machine with increment and seed as -1000 and -20. The table is created fine. But when I execture the first synchrnoize data from the client, the table is changed to be 1, 2, which is what the server has. I ...more >>

I meant to cross-post this over here, but not having much response in SQLCE forum ... I'm in the process of a 'forced' upgrade (my client bought newer PocketPCs). Soooo .. what I would like to know is whether there are any issues connecting SQL Mobile to SQL 2000 for replication. Currently, r...more >>

Been fun posting on some of these SQL newsgroups and receiving timely responses that made my day. Thanks to all who responded and also thanks to all the ones that ask questions. I only wish i could read the newsgroup postings every day Anyways Happy Holidays everyone.. ...more >>

Today we ran into a strange problem. Our publication from the publisher database just mysteriously disappeared. Are there any tools / utilities to find out which user deleted the publication? Thanks in advance, Vik...more >>

Just to let you know, I can't continue any threads I'm involved in for the next few days - I'll be in an internet-free zone until the new year. Merry Christmas to all fellow replication-enthusiasts..... ...more >>

Running Win 2k & SQL 2k sp3a I have on e main server and 15 remote servers. I am doing merge & trans replication between the remote servers & the main server. Yesterday, the main SQL server started stopping randomlly. The contents of the of the Application Event Log show the following erro...more >>

We are setting up a test laptop to use with Merge replication to a SQL 2K server that serves as both Publisher and Distributor. I was hoping to create a push subscription but that needs a register server setup that does not work. When I go to register the server (MSDE on laptop) from the P...more >>

I need to know if replication is running behind. I have already queried with distribution db for this subscriber , but it's telling me there are no transactions waiting. the agent history on the log reader shows it moving across data to the distributor normally, but when i try to shrink ...more >>

Hi, I have confired some transactional replication with puss subscrition between servers running sql server 2000 sp3. The replication works fine, but yesterday after the publication/distribution was restared the log reader agent of each publication reports this error: The process could not exe...more >>

Hi all, While synchronizing a device with my sql2005 merge replication, I get an error with a HRESULT of 80004005, no description and a native error of 0. I've searched around but couldn't find any post that would describe what that error could mean. I've tried the little advice I've fo...more >>

Hey, I've used the following script to add an article to an existing publication. But now it wants to rerun snapshot agent. Is there anyway where i could add this table and create a snapshot only for that table only and not the whole publication? Please tell me what would i have to do. I tried...more >>

I have a pull replication set up for users who synchronize data once in a week. This replication is subscribed to a NT group with 5 users. When a user is trying to synchronize the data, it is giving the error message 1069 and the service did not start due to a logon failure. Any help is ...more >>