On 22/12 I made a couple of posts to this group. On topic, with a couple of helpful replies from Hilary C/ Paul I. Now they appear to be gone! Now I've noticed this before and didn't really think much of it, but now I'm suspicious I may be being silenced for my surname. If so who is respons...more >>

I'm trying to setup a test transact replication using the Create Publication wizard. It first selects a distributor. When I indicate that it should make the publisher its own distributor, I get the message, SQL Server Agent on xxx.xxx.xxx.xxx currently uses the system account, which causes r...more >>

SQL 2000. I have a merge replication system running in a 24/7 environment that cannot be brought offline or locked up. When i try to run my snapshot agent, it locks up the primary DB (there are many tables in this that are very large, like hundreds of millions of rows). is there a way aroun...more >>

We have a merge replication configuration with the distributor and subscriber on one server and the publisher on another. The performance of the merge slows down more and more as runs. The bandwidth between servers has already been ruled out because there they run on a Sonet ring and T3 l...more >>

When i refresh the publication in EM, and look at all my subscriptions.. I see the last action column changing..i.e from 100 transaction(s) with 100 command(s) were delivered to 45 transaction(s) with 50 command(s) were delivered and so on.. Is all this information stored someplace that I ...more >>

I am looking for some advice/comments on what the best replication model would be in the following situation: We have a series of complex (slow) stored procedures that do lots of calculations but produce relatively few changes in the database. These stored procedures were written such that th...more >>

Where is a good place to look to know how to setup merge replication via SQL commands. Darin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi, We are using SQl 2000 EE with sp3a and doing transactional replication of 300+gb db. frequently the subscribers are out of sync . In order to spped up the replication process we have modfied the polling interval to '1' and commit batch size to '1000' of distribution db ,Log reader ag...more >>

Error: 29045-- Error: 0--The validity period of subscription went out. It is necessary to re-initialize. Error: 0--Subscription for 'SanyoMB_CE’publication is invalid. Context: Firstly, when I synchronized the above mentioned error occurs. Although we carry out synchron...more >>

Are there any status tables or sprocs that one can query to see current status of replication such as how may commands/transactions are still in the log that have not made it to the distribution database and also from the distribution database to the subscribers.. Like to see latency, delivery r...more >>

Im just curious to know what uses these tables that are on the subscriber dbo.MSsubscription_agents and dbo.MSreplication_subscriptions. From the profiler I can see what writes to it.. But where else is it used ? What reads these tables eventually ? Do the distribution agent reads this first ? ...more >>

I have an application that will have very limited functionality in a disconnected mode. I plan on recording operations in the one area of our application where we allow inserts in disconnected mode and updating the publisher through custom code that basically replays what the user did in dis...more >>

Hi to everybody. Situation: 1) merge replica 2) Two publications with many subscribers (about 60 for each publication). 3) One subscriber has a monodirectional agent (data only from publisher to subscriber) 4) In this subscriber I delete data older than one month 5) MSMerge_Tombstone of th...more >>

Hello,, for three days i am trying to figure out howto get replication with merge between sql server en access2K. Transactional replication is working, but I need a configuration which is independant of the network, so I need the Merge. I find all kind of descriptions on the net, but n...more >>

We are going to move Access 2002 database tables to SQL Server 2000. The current Access tables are replicated. I plan to "unreplicate" them before converting (otherwise all the repl system fields go over). However, many of the tables have AutoNumber fields that we want to convert to Identity f...more >>

Hi everybody. Does anyone know if it is possible to add a formula field as column of a replicated table? How can I do it? Thanks, Marco ...more >>

Hi all, I got this error this morning... what is the problem? everything was working fine... Executed as user: sqlUser. Replication-Replication Snapshot Subsystem: agent SERVER-SQL-Jobsheet-Jobsheet-12 failed. The process could not connect to Distributor SERVER-SQL'. The step failed. [SERVER...more >>

Dear Friends Can it be possible that i get email for the conflict as and when they appear. Your guiaence will be helpful to solve my problem. Best regards Sharad...more >>

Dear Friends I am getting the conflict for the records with following remark. The row was updated at 'SERVER1.DATABASE1' but could not be updated at 'SERVER2.DATABASE2'. Violation of PRIMARY KEY constraint 'PK__TABLE04__5DF6A344'. Cannot insert duplicate key in object 'TABLE04'. Thi...more >>

Dear Friends We are doing replication in two offices. We get conflicts for the records when the replicaiton is down. We follow the system of Continuous Invoice number. So the person should get the next number from the database. Suppose the last number is 225 then it should give 226. ...more >>

We have a SQL Server db in Atlanta. Rows are added to tables in that database by a website in Atlanta. We have a number of people who use that data in Dallas and they need to be able to modify the data. This scheme works okay except when the Internet connection between the two sites goes down. ...more >>

Hi all, I try to run a bcp out command and mark a table for replication all in one transaction. I do not want the user to update/delete/insert from the table while I perform a bcp out and mark the table for replication. However, when I use REPEATABLE READ isolation level the stored procedur...more >>

I have an article with 70,000 rows in it. I need to run an update script from the subscriber that will update all 70,00 rows. Is there anyway I can prevent these changes from being replicated? I realize I can drop the trigger so the rows are not added to msmerge_contents. I'm looking fo...more >>

Hi, I have two servers, each one has Database "Clients". Database # 1 is connected to a web application and it updates database # 1 every day. I need to syncronize database # 2 in a remote server with all data in DB # 1. I have tried different softwares that allow me to compare data and s...more >>

Dear Friends I am facing the problem in my accounting database replication there is one table with 1024 column and hence the replication is failing as the maximum size is 1024 and the rowguide column can not be created. Please guide if there is any way out to do the replicaion with 1...more >>

I could not find this sproc in any database although its being called. Where is it defined ? ...more >>

Hi, SQL Server 2000 EE , Production Environment. 1]I have a publisher database 'mydb' on ServerA. 2]A Remote Distributor for 'mydb' with Multiple Push Subscriptions. 3]one particular subscription went into out-of-sync as we noticed the failure after 4 to 5 days. 4]I Have updated t...more >>

In sp_who2 for a log reader agent , I see 3 different spids .. The programname is classified as "Servername-DBName-ID". Thats how I know its tied to the log reader. But I thought there is only one session of a log reader agent that runs for each Published DB.. So why are there 3 spids ? Thanks...more >>

Can you please list 5-10 important sprocs being frequently called by the log reader and distribution agent in a transactional replication setup and in one line explain what they do ? Thanks ...more >>

Hi all, I?ve just got a vb (6) application with source-code from a customer and was asked to 'fine-tune' and enhance the thing. Oh well, you got to make a living, don't you.... Anyway. The application uses SQL Server to store data. One SQL Server (msde) is installed on their server (let'...more >>

hi, I am working on sql server 2000 replication. One of our sql servers has multipul publications that push out to several subscribers, and some of the subscribers are the database on the same publisher server. and I've encountered the following failures with only one of its publicati...more >>

Am i imagining or does the distribution agent start writing data to the subscribers even as the snapshot is running ? I just tried to replicate a huge table ( 50 million records ) and while refreshing the replication monitor i could see both the snapshot and distribution agent writing records....more >>

Hi, I have a trouble between 2 SQL Server 2000 with a transactional replication w/ immediate update subscription. Both servers are in a diferent network separated with a firewall. This is the error: Server: Msg 7391, Level 16, State 1, Line 5 The operation could not be performed beca...more >>

What locks are being held during the initial snapshot on say a table that has 30 million records ? Is there a bcp to a file being performed ? Thanks ...more >>

Hi, This is the first time I ‘m setting up Merge replication so pardon my mistakes. I am trying to replicate a database from one server in one data center to other server in other data center. I set the distributor and publisher. Now I want to set up a pull subscription from the remo...more >>

I wonder if anyone can help me. I have been given the job of coming up with a scenario of SQL Server -> SQL Server replication that is secure. Both SQL Servers will be behind firewalls at different geographical locations, and in different domains. I know you can encrypt traffic using SS...more >>

Hallo, i'm trying to get my replication started, everything seems to be fine, only the initial snapshot does not start. The folder where the snapshot is (to be) saved, provides all rights to everybody - just that folder, of course. I was told that maybe the snapshot agent doesn't have the ...more >>

Hello All, I am using a Merge Publication and I have a application in which I need to programatically change the status of a Subscriber for that publication (active or inactive). Can anyone tell me how to do this? I'm currently using VB.Net, but any example will do. There is a sp_changesubs...more >>

on one distributor, the min entry_time in the msrepl_transactions for the publisher isis just a few hrs away from getdate() and then on another distributor, its 2 days old .. All my subscribers are current in the transactional replication.. so why are these transactions still there and also in t...more >>

Right now my replication jobs for transactional replication are owned by sa.. What happens if we change the authentication mode on SQL from mixed to Windows only ? Will the jobs fail ? And do I then need to change the owner to a Windows account ? Thanks ...more >>

Using transactional replication and how can we confirm all data is in sync between publishers and subscribers ? ...more >>

I want to see the commands in msrepl_commands table. Using transactional replication and want to know whats in this table. What clears of the contents from this table and when ? ...more >>

Hi, I looked at the services running on my machine, one of service called "sqlserveradhelper" is not running. Just out of curiocity, what is it for? ...more >>

Hi, I went to Publications Folder in EM, I highlighted and click on one of the replications, on the right window, some information about this replication pop up, subscription Name: Server-01:users Type: Push Status: Deactivated subscriber: server-01 subscriptionDB: users Obviously, so...more >>

I have set up a transactional replication with immediate updating subscriptions, Distributor and Subscriber on diff servers. When I try to update rows in the subscriber I have the following error: [Microsoft][ODBC SQL Server Driver][SQLServer] Login failed for user 'sa' (Both servers ha...more >>

If with a merge publication we limit the number of simultaneous merge processes say to 5 for 100 subscribers, do the 'waiting' merge agents complete their tasks in an orderly queued fashion or is it just pot luck in what order they complete? Is it possible that certain agents might be 'unlucky' ...more >>

In a merge replication application with 100 subcribers the merge process is generating large numbers of locks on the published db and causing performance problems. One suggestion was that we subscribe all external (VPN on ADSL) merge subscribers to a subscribed copy of the database created ex...more >>

We use merge replication where data created at a control centre, then modified in a filtered publication at the subscribers. We currently have about 100 subscribers. Publication is filter is WHERE LocationRef=XXX We need to retain data at the control centre but not at subscribers, so does ...more >>

I am seting up log shipping from a production SQL 2000 Enterprise server to a similar server in our Disaster Recovery Site. Various problems with log shipping have forced to rethink its use. I was wondering how replication stacks up against Log Shipping, especially in the areas of fail over a...more >>

Windows 2003 Server Standard, SQL Server 2000. Two identical machines. Primary (P) and Secondary (S). I have set up merge replication with P as the publisher and S as the distributor and an updating pull subscriber. The machines are installed at a customer site and were successfully put into t...more >>

I have designed a replication for 3 servers,It was working correctly. but after deactivating the servers and then activating them, sql server doesn't synchronize the databases.subscribers are active but they don't synchronize. what must I do? ...more >>