I am using Sql Server 2000 and MSDE. I want to use merge replication. The primary database is on the SQL Server. When I install the client app written in VB.Net, should the client create a local identical DB to the one on the server or is there a way to pull down a copy of the database from the ...more >>

Hi, I am planning to setup replications on my SQL Server 2000 BOX ( publisher + Distributor) and subscriber on another BOX . I use Mixed mode authentication for both the boxes and it is MUST for my applications to communicate with SQL server. Do I need to worry about authentication modes...more >>

I had asked the this question in here before, but i lost the answer, and actually didnot understand the answer clearly. I have a main server MSER as publisher. and 2 server SER1,SER2 as subscriber. I want to install new server NEWSER. NEWSER is a subscriber from SER2 while in the same time SER...more >>

Hi, I am quite new to SQL replication, but have manged to configure snapshot replication of a database to a "hot standby" server that I would like to have as a recovery option in case of a system failure of the primary box. This database uses SQL Authentication, and my question is how I can ...more >>

Can native SQL Server replication perform any sort of transformation and business logic as part of the replication process? When asked this my response was no I didn't think so; it is only a replicate of the data "as is" from the publisher to the subscriber. Is that correct? This question is ...more >>

I hope I'm missing something here .... but it seems to me that if I set up replication over the internet (with ftp) and allow anonymous subscriptions then anyone who knows the publisher and database name can access the database. Is this correct ? -- Michael Tissington http://www.oaklodge...more >>

Following solution was sent to me and I tried it but it is not solution. Sorry, there is different idea for this problem. Old Solution Idea: Check to make sure SELECT @@SERVERNAME returns correct servername. If not then you will need to run sp_dropserver <wrong servername> and sp_addserver...more >>

I have set up replication for a database. I noticed that eventhough I have unique primary keys in each of my tables, sql server adds rowguid fields to the tables that are articles in the replication. How can I avoid that?...more >>

I am currently developing an application that utilizes SQL Server 2000/MSDE using replication. What I am finding is that when the client is not attached to the network (in the case of a laptop, etc.) the replication will attempt to contact the subscriber 10 times and then it no longer tries. I the...more >>

while I am configuring publisher and distributor, at final state I met an error: Error 18483: Could not connect the server (xxx.xxx.xxx). Because distributor_admin is not define as a remote login at the server. Why?...more >>

I could not find info rg err 206 in BOL? message is : operand type clash: unique identifier not compatible with int (error 206). I was creating a transactional replication publication and some of my table columns are "int". Does this error mean I have to change the data type for transactio...more >>

I tried setting up a Merge Replication between a MSDE 2000 and a SQL Server 2000, and got the following error: The process could not enumerate changes at the 'Subscriber'. Anyone have any ideas how to fix this? *** Sent via Developersdex http://www.developersdex.com *** Don't just parti...more >>

I tried setting up a merge replication between a MSDE and a SQL Server with a Pull Subscription, and got the following error: The schema script '.sch' could not be propagated to the subscriber. Any ideas how to fix this? Thank you! *** Sent via Developersdex http://www.developers...more >>

Hi All, I want to do the transactional replication. Wanted to know what type of schema changes in Publisher database can not be done, without initialising the Subscriber. I know that delete a column or adding a column in a published table can be done through two "sp_...". [ alter table co...more >>

We have a development system that we are using to test our replication setup for a SQL 2000 back-end application. A couple of weeks ago we had replication working with a publisher/distributer and a subscriber. We have been testing seperating our publisher and our distributer servers into seper...more >>

HOW CAN CLOSE THE DOS WINDOW (CTRL-C TO CLOSE IN THIS WINDOW SAY) WHEN THE REPLMERG COMMAND FINISH YOUR JOB ?? I RUN THIS COMMAND FROM AN VB 6 APPLICATION. EXIST A PARAMETER TO CLOSE THIS ? THANKS TO ALL !!|...more >>

Hello, What happens when the publisher becomes unavailable in a merge replication scenario. Will applications still be allowed to read/write/access the subscriber? Any help would be greatly appreciated! Thanks in Advance....more >>

I tried setting up a replication between an MSDE (Subscriber) and a SQL Server 2000 (Publisher) with a Pull Subscription, and got the following error: The schema script '...sch' could not be propagated to the subscriber. Any ideas how to fix this? Thank you! ...more >>

What is the best way to configure merge replication for use over the Internet. (VPN is not a vaible option) Thanks. -- Michael Tissington http://www.oaklodge.com http://www.tabtag.com ...more >>

How do I create subscribe to a subscription using the Windows Synchronization Manager and FTP ? Thanks. -- Michael Tissington http://www.oaklodge.com http://www.tabtag.com ...more >>

Hello. We would like to know if it is possible to publish from SQL 7.0 to a distributor/subscriber running SQL 2000? This, of course, would be a pull subscription Are there any articles that discuss this Thank you ...more >>

I understand Merge Replication well but I'm new to Trans Replication and can't find any help on the Net... For Trans Replication (Queued updates + Updatable subs) then can the Sub db be updated if the Publisher is unavailable? (E.g. Network error.) Using Trans Replication as above, how wo...more >>

Hello, I have a question about how to interpret the column "number of updated rows on subscriber" in replication monitor for a merge replication. Does it really mean that someone on the subscriber has updated this number of rows or is this value influenced by changed rows from the server or...more >>

I have 1 table to be merge replicated to 2 other servers (DATA5 amd DATA5R). Whichever server I push a subscription to first works just fine. The second server get the following error. Table 'UPDATE_LOG' does not exist in the Subscriber database. (Source: DATA5R (Data source); Error number: 21...more >>

I just set up transactional replication w/ push subscriptions for the first time. Everything works well, but when one of the subscribers is unavailable due to a network problem, the distribution agent for that subscription stops and I have to manually start it again. I have it set to con...more >>

Hi, We are planning to Implement replications on our SQL Server 2000 Standard Edition which is already in production since more than a year. we bought a new server and SQL Licence which will act as subscriber. I know logshipping is better option but we cannot afford for Enterprise Editi...more >>

Hi All Unfortunately My queue reader agent and job failed becuase we did something wron in the subscriber. Later the we inserted the correct one in publsiher database, it is going well now. But when we try to run QUEUE AGENT or Job it is showing same error and it is failing How to delete that tr...more >>

I have a developer who wants to work on a copy of a production database where the data is constantly current. To do this I set up transactional replication. Now she wants to know if she can edit data on the subscriber without messing up the replication. In other words does SQL Server 2000 send th...more >>

In transactional replication with push publications, what tables can be inspected (on either the publisher or subscriber) to see which replcmds made it to the subscriber? If there is a good treatment of the distribution db tables and SP's, that would also help. thanks. ...more >>

Hi, Has anyone had experience with maintenance plans killing the log reader in SQL2k? My maintenance plan runs every other day with the follwoing options Reorganize data and index pages Change freespace per page percentage to 10% Check Database integrity Include ...more >>

Hi, My questions is we want to make a copy of a database onto the same server while preserving the diagrams, stored procs, etc. We stopped the SQL service and made a copy of the data and log files. We attempted to ATTACH the file copies (after re-naming them), but the embedded file inform...more >>

I have two publications, one is merge, and the other is a snapshot. The snapshot publication and subscriber appears to be working correctly. However, I have a red 'X' on the publication for it, and also a red 'X' on folder for the distribution agent. Although it appears to be working correctly...more >>

Env: SQL Server 2000 SP3a on Windows 2000/2003 Server Is there a way to remove an column (of text data type) from an article in a transactional replication publication w/o re-initializing all of the subscriptions? I don't want to actually drop the column from the table, but just stop replicat...more >>

I have one publisher with two push subscriptions on the same server using transactional replication. When I update the table that is being replicated (I issued a command that updated 23,000 records), the push subscriptions lock up their table and never complete. I've waited literally hours! I'...more >>

Hi, We are using transactional replication with queued updating between SQL2000 Servers SP3. 1) The queue reader fails sometimes(often) the error message "Queue Reader aborting. The step failed." The error details shows errors like: Server: ... , Database ... : ODBC Error:Invalid SQL data type ...more >>

I'm planning to use merge replication with updatable subscriptions using 4 machines on a LAN. My components update the local db only (2 GB size) and the changes are then continuously replicated to the other machines. When my publisher is unavailable due to a network failure then I want one...more >>

Hi Setting up a replication I encounterd the following problem Setting up server A and B is pretty easy to do, assigning the rights on server A and server B gives no problems, scheduling the replication is no problem but... When the databases starts to replicate from server A to B ( creating a ...more >>

Hi, Is there any one who belong on this newsgroup tried snapshot or merge replication between SQL Server 2000 running on SBS2000 ? How could it be possible ? Thaks to all who interest,...more >>

I have often seen the question in these newsgroups about the order of articles, but no definitive answer! (a) can the order of synchronization be set? (b) if not, what is the default order? TIA, John...more >>

Hi All I am looking for a guide/FAQ/example code to help me with using VB.Net and T-SQL to create a publisher and set up replication between SQL 2000 and MSDE (Also SQL Server 2000) Any pointers much appreciated. Thanks John ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secu...more >>

After deleting a publication you are supposed to manually delete subscriptions at the the subscriber. "Must" this be done before disabling replication at the distributor? I deleted the publication and forgot to manually delete subscription info remaining. I've disabled publishing. Now I cann...more >>

Hi al I have a scenary SO Windows 2003 Enterprise edition 64 bits, I built a cluster on two nodes ... than install SQl Server 64 bits i beginning to choose Virtual Server, choose the group SQL Server disk , put the name instance and finished when executing the setup of SQL Server CD again, to cr...more >>

I added an article to an existing Transactional publication. I noticed the system did not warn me about the rowguid column nor was it added to the new table that was just added to the publication. The replication seems to work fine but how come it didn't need the rowguid column? All the other t...more >>

I have a server (server A) with about 250 separate databases named 1 to 250. I need to consolidate these databases into one big database on another server (Server B). Server B is the publisher, I want to create 1 publication on Server B with 250 push subscriptions using dynamic filters to keep the s...more >>

Hello: We have a merge replication on a ActivityLog table from Server X to Sver B. We have this merge replication set up to run every 5 minute daily. We run into a problem when both sides of servers trying to insert new records at the same time (when they get replicated, they try insert ...more >>

Hi In have transactional replication running in our test environment, recently one of our developers truncated the publication databases transaction log. not sure if this is what caused the problem. The log reader agent then failed. It would start up and then fail reporting no response in last...more >>

SQL Server 2000 (Service pack 3a) I have a table set up as an artcile to publish all columns in the table. I need to create another article with just the primary key and six status fields and publish to another table. Is this possible? ...more >>

Hi I've been monitoring our replication setup for the past few days and have come up with some disturbing issues. Our replication generates an awful lot of conflicts when subscriptions synchronise. I investigated the cause of these conflicts and saw that 99% of our conflicts was due to foreign k...more >>

Is there a way using T-SQL (or any other way) to change the "Identity Seed" value of a field in a table....more >>

Hello, I have a scenario where I need to ensure data synchronization between a particular db on SQL Servers residing across remote sites but on the same domain. Every once in awhile the application will write data to the secondary server which at some point has to be written back to th...more >>

While running Transactional replication on sqlserver 7 we noticed that when an update command was executed on the source database successfully It will not cause the Distribution Agent to error out if for some reason that same primary key does not exist in the Target db. Looks like some kind...more >>

I need to find a good book on SQL Server 2000. This book needs to have a good and detailed section on Replication. I have to create a App, that will Sync to SQL Server thru Access and SQL CE. But I have not been able to find something that tells me how to setup SQL for the Publications. Th...more >>

I have a large table (approx 43million rows) which I need to replicate. The problem I am getting is that after going through the replication process (Setup Publication>Snapshot>Bulk Copy) the distribution agent then just sits there with the message 'The process is running and is waiting for a respon...more >>

I have a publication to which I want to add a few new articles. I use sp_addmergearticle and get an error "Server: Msg 20607, Level 16, State 1, Procedure sp_mergearticlecolumn, Line 490 Cannot make the change because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force...more >>

How can I obtain the following info about the particular record in the subscriber's database (SQL2K merge replication): - has the record been updated at the subscriber - has the record been inserted at the subscriber - none of the above (record is the same as when downloaded) I am asking this b...more >>

I have been stuck on this for the last week... I cannot create a new database on our Sql server, I have recently taken over management responsibilities on an existing SQL server (2000). Apparently at one time, it had the Adventure Works CRM database on it that has since been removed. I was t...more >>

Why are some views and articles cannot be publish as new articles when they work fine? What factors can stop a view/Stored procedure from being published??? ...more >>

Hello, We are setting up transactional replication to separate reporting from online processing. Our database is not too big but we have a high availability requirement so we need to minimize the time the database is down. We are particulary concenred with the time it takes to perform a snaps...more >>

The subscription to publication 'replication test' is invalid. (Source: Merge Replication Provider (Agent); Error number: -2147201019) ---------------------------------------------------------------------------- ----------------------------------- The remote server is not defined as a subscripti...more >>

Hi, We are going to upgrade our SQL2000 EE to SP3a. There is one thing what I found in SP3 readme document.( if you are using merge replication and the Distributor is located on another computer or database instance (a remote Distributor), after applying SP3a you must generate a new snapsho...more >>

Hello, We are trying to setup replication to another sql server via the internet. We get the following errors: The merge process could not initialize the subscription. (Source: Merge Replication Provider (Agent); Error number: -2147201011) -----------------------------------------------...more >>

While testing Log Shipping for production we noticed that a Data/Index Reorganization on the Primary Server caused a large (70% of the size of the Primary Database) transaction log to be generated. Is there any way to avoid this? Transferring multi- gigabyte logs between servers that are ...more >>

I am running SQL Server 2000 with service pack 3a and Windows Server 2003 SE. We programatically create three tables daily and add them to replication as articles, but I don't think that they replicate until the next nightly snapshot is run. Is there a way to immediately replicate the three ne...more >>

Hallo SQL 2k SP 2 Win2k I made a SnapshotReplikation for Database1 to Server1 - no problems Then I made a new Replikation(transactional) for Database2 to Abonnent=Server2 The folder where the new snapshot should be is been set automatic from the assistent. The folder is empty and I got the ...more >>

Hi there, On out distributing server I receive the following message: Replication-Replication Transaction-Log Reader Subsystem: agent AIRWARE_SQL1-Airware-3 scheduled for retry. The process could not execute 'sp_replcmds' on 'AIRWARE_SQL1'.. This has happened several times now. I have looke...more >>

Hi to all, Setting up a replication ( new to me in SQLserver ) was first attemped on my local SQLserver within one instance between two databases. This worked just find. Trying to replicate from one server to the other ( testserver to my local installed SQLserver ) gave some problems. Each time...more >>

Can SBS 2000 with SQL replicate to another SQL server....more >>

Am setting up merge and want to understand it so it can be optimised. There is a flag on the agent - MetadataRetentionCleanup. What does this do and when? Presumably it doesn't remove all metadata? How old is the metadata before being removed? If I don't synchronise for eg 3 weeks, ...more >>