This is occurring regularly on SQL Server 2000 build 878. The problem is a deadlock in the Distribution database. The Distribution Agent spid is executing the SELECT statement below: select @max_xact_seqno = max(xact_seqno) from MSrepl_commands (READPAST) where publisher_d...more >>

We are using SQL 2k and use push replication. If I want to add a table, a view or a stored procedure to a publishing table, view or stored procedure, can I just create them using EM or query analyzer manually in both the publishing table or subscribing table without involving replication? ...more >>

Hi , where can i find a goog tutorial for mssql server replication step by step ? thanks for answers ...more >>

Hi, We are using Push subscription in our transactional replication setup in SQL 2K and I noticed that the SQLSERVERAGENT service is started by a local account called replicationAgent. Is it a problem for me to change it to a different local account? If it is ok to change it, do I need t...more >>

I am desperately hoping that someone here can help me so that I can stop my premature balding. I am running SQL Server 2000 on two servers both running Windows 2000. I have a snapshot replication setup from Server1 to Server2 where Server1 acts as the distributer and contains the published dat...more >>

My goal is to create a warm standby using transaction replication with instantaneous updating to the subscriber. I only have two servers. Should I place the distribution database on the same server as the publisher or the subscriber? Is it even possible to place the distribution database on...more >>

Hi, I used "select * from replicate_table_name" in my stored procedures and my application.Now i want to replicate that tables. Will it affect my application and Replication. Please Advice me. Regds Soura ...more >>

Hello everyone. We are evaluating SQL 2005 Standard for both a mirroring and log shipping scenario. We want to have database mirroring setup in house and log shipping to a remote site. We have successfully implemented db mirroring using the trace flag 1400, like this..... sqlservr -d"c:\...more >>

We are moving to SQL 2005 Standard Edition are use numerouse filters for replication. In SQL 2000, we had a lot of the filters setup using an OR statement in the filterclause (ie. a.company = b.company or a.subcompany = b.company), and had no problems with adding the filters. In SQL 2005, cre...more >>

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 >>

I have transactional replication setup on a pair of SQL 2000 machines. The issue i have is, one of the tables has over 285 columns. I understand that SQL SERVER 2000 limits columns to 255. Is it possible to filter out unneccessary columns before i add the article to the Publication? I found out ...more >>

SQL Server Enterprise manager showing Distribution database as SUSPECT and in result replication monitor do not show any information about replication agent(Merge agent etc). I detach database and try to re attach but system showing that database cant be attached as "log scan" to those file is ...more >>

We're planning on upgrading our SQL Server 2000 publisher to 2005. It has several MSDE pull subscriptions. I am trying to get Northwind as a Publisher to one MSDE subscriber but I've been having lots of difficulty. I have created the publication and the pull subscription, but the subscriber...more >>

Running SQL 2k SP3a & Win 2k Today, all of a sudden, my SQL server started going up and down. In the System Event Log, I received the error Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7031 Date: 12/21/2005 Time: 3:37:50 PM User: N/A Compu...more >>

The following sp runs about 3 in on a 2005 ssds server and it takes a few seconds on a much slower machine running sql 2000.... I am trying to move all our replication to the new environments and setting everything up except the articles manually. Is this the best way to do it? exec sp_ad...more >>

I would like to replicate a large database to a reporting server on the same network. I have very good bandwidth between the two servers The DB in questio is ~200GB and has a transaction rate of ~3000 per minute. There are 10 tables that are > 10 GB's. Does anyone have any advice for me? o...more >>