After synching a handful of subscribers, I reviewed the data that came back and realized I forgot to set auto range identity on two tables that required it. So I dumped the pub, dumped the subscriptions, manually assigned the identity values to consecutive identities, reset the identity column...more >>

hi all; i have a problem with a view which uses an sp . while appyling the snapshot, the agent complains about the sp that view uses. i used to think that agent take care of dependencies but it is not as in that case. i drop publication and add the view as the last article of the publi...more >>

All, I have setup transactional replication in our dev environment with publisher, distributor and subscriber on same box for testing and it was running fine for some time. When I was setting up replication I had SQL Service logged on using local system account and sql agent login was dev a...more >>

Hi Please advise where can I find free info on possible Microsoft SQL Server 2000 transactional replication issues and considerations in addition to what's written in the BOL? -- Many thanks, Oskar ...more >>

Hello, I have a database in SQL Server 2000, on which created publication and it has one subscriber . now if I change in data structure , following error occured. 'EMPMAST' table - Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot add columns to tab...more >>

Hi, Is it possible that a table that is member of a publication, be subscribed to a subscription to receive replicated data? Thanks in advance, Leila ...more >>

Hi all, Usually , I will create a snapshot folder and share it on computer running SQL Server for MR. Now I have a question: Can I create a snapshot folder on another computer which is running IIS (For merge replication with SQL CE). The computer which is running SQL Server was not installed I...more >>

Hello; I have worked my way through numerous connection problems and login issues, but I’m left with one problem I’m hoping I can get some help on: I’ve got an SQL 2000 v 8.00.760 SP3a, with a production database I’m trying to replicate from one workgroup to another (yes, workgroups ack!) ...more >>

We are designing an application that will use merge replication from a wireless laptop back to a server. Plan on using MSDE on the laptops, can the central P.C. that will be on the other end use the MSDE also, or does one of them need to be full blown SQL Server? Thanks, Steve...more >>

Hello guys, we have a problem with the merge replication in my company, the downloads replication is very very slow all times, the upload process is very fast, but, when the download process starts, then the suscriptor crash and the locks begins to appear in the database. The processor usage ...more >>

Hi - I have a peculiar problem. I have been able to successfully add merge articles to a publication (both in script and through EM) with identiy range in a instance of sql server. Whenever I try to do the same thing in a default installation of sql server, I get a syntax error. I h...more >>

Hi, I have set up transactional replication for a database from one db server to a second. The replication is working fine but the distribution database constantly grows. The size of the replicated db is 524 MB, the size of the distribution db is 24 GB, growing daily. How can I shrink my...more >>

We have a situation where if the subscriber becomes unavailable for an extended period (say over 15 minutes), the distribution agent at the publisher will make several attempts to re-connect to the subscriber. Once the subscriber returns to service, the distrib. agent remains in 'failed' status ...more >>

i have a publisher agent that generates 61 articles for publication without a problem. however i'm having trouble understanding exactly how the distribution agent executes. when executed manually once, it ran successfully, and the subscriber got the data. is it possible to run the distribut...more >>

Hi Does the DTC service need to function properly if I plan to use transactional replication between two Microsoft SQL Server 2000 machines? -- Many thanks, Oskar ...more >>

Hi How can i do replication from one db to another.I am having a master db and i want to replicate all the modify records,new insertion of record from master db to another databases on diffrent servers . This diferents servers are connecting through isdn line.Which kind replication i can use...more >>

i am replicating all tables in SERVER1 MAINDB (publisher) database to SERVER2 COPYDB (subscriber) database. but the distribution agent creates the tables in COPYDB under the dbo user. how do i specify a different user in the COPYDB database to create the snapshot tables under? ...more >>

I see how to remove replication objects and configurations from a replication distributor, disregarding any existing dependencies, by running the following SQL at the distributor server: sp_dropdistributor @no_checks=1 This suffices for my present servers configuration. However, I would p...more >>

On page 50, you discuss replicating SQL Server to Access. Two questions: 1. While you discuss all 3 replication types, it sounds like you are recommending Merge as the solution? 2. In the hint, it says in part, "all transactions occuring on the Merge Subscriber [Access] will be "published"...more >>

Several times over the course of a month, our network admin team performs necessary maintenance due to company moves and general growth. During this time the connection between my Publisher and Distributor is disconnected. My Subscriber and Distributor are on the same server. I have three tra...more >>

Hello, Anybody know who I might call to pay for help setting up replication. I am under a time constraint. -- Rick Rushing System Administrator D & J Construction...more >>

Hello I am under a time constraint...anyone know who I can call to pay for help in setting up replication between 2 SQL 2003 servers? -- Rick Rushing System Administrator D & J Construction...more >>

Hello, When I have a table which I want to replicate and this has as primary key a number, I read that it is easier when I use a unique identifier than for example a number which is automatically incremented. Why it is easier to handle the replication with a unique identifier than with an...more >>

Hello, I read in articles that there can occur two kinds of conflicts during replication and that the SQL Server Reconciler solve such conflicts: 1) If more subscriber try to modify a row on the publisher database at the same time. 2) If a certain row is modified at the subsriber databa...more >>

Hello, Why is it better when I want to replicate a table to use a unique identifier as primary key than for example a number which increments automatically if a new row is added to the table? thx mat...more >>

Hello, I read in articles that the SQL Server Reconciler solves conflicts which can occur during the replication. The kind of conflicts are: 1) If more subscriber want to modify the same row on the publisher database at the same time. 2) If a certain row is changed at the subscriber d...more >>

Hello, What is the difference between the term Synchronization and Replication? thx rob...more >>

Hi friends, Can someone help me on this? I have set up transactional repl between the primary site and secondary site for 2 databases. Both transactional repls are bi-directional. Now the publication for one db works file but it did not work for another db. The distribution agent was saying...more >>

I got this error when distributor running, however i perform replication of full database. On publisher and subscriber there are identical database. Any ideas???? -- Message posted via http://www.sqlmonster.com...more >>

ho fatto un update che non dovevo senza fare backup prima come posso ripescare i dati??? gia committato ovviamente carlo ...more >>

Greeting! I have a Merge Replication setup with Dynamic Filter Hostname( ) and "Exchangetype 1" and Conflict resolver " Microsoft SQL Subscriber always wins the Conflict Resolver" (I want only my subscriber changes to be uploaded to central publisher) However, today I noticed some problem w...more >>

Hello, I read serveral articles about the mechanism of replication from a sql server 2000 database on desktop with an mobile device running windows mobile. I want to remark my understanding fo the replication mechanism and wanted to ask you if you could give me feedback if I understand i...more >>

If you are doing a merge replication between a wireless laptop and a server, and you lose wireless connectivity during the replication, what state are you left in? Does it know enough to rollback changes, or are half of them done and half not. Thanks, Steve...more >>

Is there any way to generate a script for the subscribers of a publication? I know you can generate scripts for the publication, the distribution database, the replication jobs, but have not found anyplace where you can have EM generate the SP_ADDSUBSCRIBER script. Any help would be appreci...more >>

Added a column to one table with sp_repladdcolumn in publisher/distributor. This warning comes from every publication this table belongs to: Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_sel_C245F32C38A611D525494BFC6FD140A7_pal'. ...more >>

Is it possible to do all of the replication (Merge) exchanges from stored procedures? I need a way to run a Merge replication from laptops when they are connecting to the network after being out of the office. Thanks. David ...more >>

Hi, I am getting this error with Transactional replication for a table which has column data type text, and has no data in it. "Error: 4813,Expected the text length in data stream for bulk copy of text, ntext, or image data." Any idea why I am getting this error. Thanks Shan...more >>

Hi, I am dealing with merge replication. I ran the following two queries 1. SELECT MAX(IDENTITYCOL) FROM tablename 2. DBCC CHECKIDENT(tablename) The result of the 1st query and the current column value in the result of the 2nd query should be same...? Some times it differs. ...more >>

Can anyone point me towards a source code listing for a working replication custom resolver written in .Net (C, VB etc dont mind which)? I just need the skeletion of it and not the actually implementation of the conflict resolution. cheers ...more >>