Totally stumped. How I got here ... I've had a database set up for merge replication. Initially it had 2 publications, but I just scripted them out and deleted them when I ran into this issue, so there are currently no publications on the database. I had some scandisk errors that had affec...more >>

Hi all, i found an error in my transactional replication, from the MSrepl_errors table, one of the error_text is "{CALL sp_MSins_MisFlightScheduleSector (N'KUL', N'CHI', N'KUL;SIN;CHI', 2004-12-29 04:03:00)}", when i run this query in the query analyzer with the subscriber's database, it show...more >>

I'm looking for an explanation of the -UseInprocLoader parameter. Everywhere I look I see the stock definition with no explanation of what it actual is and does. Can any one define what this parameter does or is? ...more >>

Hi, I have a table that is in both merge and transactional replication and I would like to add a column to it. Typically, when I add columns to tables in replication they only exist in one table, so I just go to the publication properties and add it use the add column button. This time I am...more >>

Hello All I am new to SQL and facing problem creating merge replication, searched MS site but found nothing on it I have created a new merge publication with all the tables in a DB, this error occurs wile snapshot agent starts to create the snapshot error is Snapshot Agent Error Details...more >>

Hi All, I'm using a custom conflict resolver (using stored procedure) for one of any articles. I want to determine which columns were in conflict in this stored procedure. Could you pls point me to some pointers on how to achieve the same. Thanking you...... ...more >>

I want to be able to replicate large volumes of data over the Internet between SQL Server 2000 databases. The transmissions would be once per day, need to be secure, and are to a location three time zones away. What do you recommend for testing, security, support (the whole nine yards)? TIA Geor...more >>

Hilary. I am looking for the troubleshoting section of your book about the snapshot agent. Basically, it says you really shouldn't have many errors when it comes to the snapshot. I have these settings for the profile. -bcpbatchsize - 1000 -hisverboselevel - 2 -logintimeout - 30 -max...more >>

I would like to add a field to a table that is the target table in a transactional replication. The source table does not have this field (and never will). Can it be done without interfering with the existing replication? Thanks in advance, /Anders...more >>

Hello, What are the steps for changing the identity range values? We have backup the database that contained initial publication with identity range set to 1000. Now when I delete the existing database with replication, and then create a new DB with same name and restore the database it maint...more >>

I am receiving the following errors in the event viewer: Application log SubSystem Message - Job 'BOS01-253-USICOAL-1' (0x5E7E64490BAF924BB783E4C4F54C3E19), step 2 - SQL Server Agent could not access the replication agent. Use the DCOMCNFG utility to confirm that the SQL Server Agent Win...more >>

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