Dear all, I have an application running on a production database. And now, I want to change a column of data to another of value and compare the result between them. Since the data in production is changing. I need to synchronize two set of data except the testing data. For do that, I ...more >>

Hello I'm trying to figure out how to set up replication over an internet connection using TCP/IP and FTP. I have configured the publisher/distributor server to use ftp as per books online. However, I cannot figure out how to connect to the publication from the subscriber. The first step of the su...more >>

COuple of replication question 1. Does the product automatically recover conenctions after an outag 2. Does is automatically complete all rep. tasks that were not completed after it went down 3. Any restriction on the number of systems (I think the distributor "node" can replicate to multiple sub...more >>

I'm performing Merge Replication between SQL Server 2000/SQL CE using Dynamic Filters I would like a conditional filter based on the Host_Name(). I've written and tested a UD in Query Analyzer called SELECT_Stores_RepID. In the Dynamic Filters properties for th Stores Table I've tried many diffe...more >>

Is possible to create a Setup Project of a Reporting Services Project to install it in another Server ?...more >>

I'm investigating replication or DTS as a possible solution to my problem. I'm looking to replicate data from one server to another, I want all of the columns of one table PLUS another column from another table to transfer to the other server. For example on Server A, I have a table foo. ...more >>

Dear All, Our Production server crashed and is currently being repaired. When Its back on line I am going to copy the infomation from our DRS Transactional Replicated Server to the Production, however I would like to ask a couple of questions. 1. Our distributor is on our DRS server, how...more >>

Hi Got a question on SQL Replication I have three different SQL server with identical tables(but not data) as I have to consolidate the data from these servers into a central database.So I did set up a transactional replication on each of these servers(Publishers) and a pull subscription from this...more >>

Hello, I am trying to setup merge publication and receive the following error: SQL Server Enterprise Manager could not configure 'DEV' as the Distributor for 'DEV'. Error 18483: Could not connect to server 'DEV' because 'distributor_admin' is not defined as a remote login at the server. ...more >>

our server administartors want to shutdown the kerberos service on our servers due to some problems in active directory. When they do this, I can no longer connect to the sql servers through enterprise manager from my machine (login fails) nor does my merge replications work. I dont know v...more >>

How do I cleanup/delete all the tables, views and stored left behind after removing replication from a database? Thanks Emma...more >>

Hallo! Are deferred updates possible in MSSQL2k? I don't found anything in BOL. Thanks Thomas ...more >>

With the sp sp_helpmergesubscription the status of a subscription can be retrieved. BOL tells about this status "Status of the subscription: 0 = All jobs are waiting to star 1 = One or more jobs are startin 2 = All jobs have executed successfull 3 = At least one job is executin 4 = All jobs a...more >>

Hello I have a merge replication problem has been driving me nuts for the last couple of days and I haven't been able to find any information on it from other posts in this group. The problem is that extra uploads (as UPDATEs) are being sent to the publisher when the subscriber sync's. First o...more >>

I have many publication that create on sql 7.i want to upgrade my sql to sql 2000(Only publisher but not Subscriber).can i do this? how?...more >>

A central subscriber whose table is updated by multiple publishers and the transactional push replication breaks on one of the publishers. Does a. If you do a new snapshot for that publisher does it automatically delete the existing data in that table for that publisher assuming you have the ...more >>

Hello i sent this question on the group but i could not understand whay should i make as i am new in replication. please give me detailed steps for this question. I made merge replication between 2 machines successfully. BUT, when a user on each machine insert a new row in the same table i...more >>

I'm investigating replication or DTS as a possible solution to my problem. I'm looking to replicate data from one server to another, I want all of the columns of one table PLUS another column from another table to transfer to the other server. For example on Server A, I have a table foo. ...more >>

Hi I have a strange scenario occuring and have no idea why I have SQL Server 2000 & Windows 2003 Server running on two machines. Two databases are set for merge replication. The subscriber is used purely for redundancy reasons and no client uses it unless the publisher is unavailable. While ...more >>

I am set up with SQL Server 2000 with transactional replication. My replication was stopped for maintenance for two days. What is the easily way to restore my transactional replication. Please help me with this issue. Thank You, Dan...more >>

I am running SQL Server 2000 Enterprise Edition with SP3A with transactional replication. After my snapshot is created and sent to the reporter database. I checked the database 30 minutes after the tables and data were sent to the reporter database. The database number of rows from ea...more >>

If I add Primary keys to tables in order to replicate them, is it also = necessary to change any stored procedures doing inserts? I thought I read a post that stated as long as the insert was not doing = a "Select *" on the insert, the sp should be ok. I am, however, = receiving an error when...more >>

I am using merge replication between SQL Server 2000 sp3a running on windows 2000 server sp4 and sql server ce 2.0 over gprs. First time when I synchronize is working fine, but when I add or modify data in sql server ce database and try to replicate over gprs I get error 28037 (A request to send...more >>

We are doing merge replication between a central server and multiple anonymous clients. We use a filter on one table and joins to related tables to determine what records to merge. There are two parts to the filter, one is user, which merges only records assigned to the user that is replicatin...more >>

Running SQL Server 2K. I use transactional Replication. It is sometimes necessary to take precautionary backups during business hours for various reasons. However, I have noted that backups made while replication is running can not be made without causing an error during Restore. Is th...more >>

I have SQL Server 2000 Enterprise Edition with SP3A with transacional replication. I have 5 articles that are set up with transactional replication. Each article has apprioximately 90 tables. My SQL Server replication log reader stopped with the following error: The agent is suspec...more >>

I am trying to replicate stored procedures (after the fact) using the following script EXEC sp_addscriptexec @publication = 'BSC_UserPubl', @scriptfile = '[\\MGROVEDB10\data$\ReplData\iDeal\DynSnapShot\Script\MGroveDB10_Ideal_Client_Repl_ScriptVER1.sql]' , @skiperror = 1 and i g...more >>

Can anyone tell me how a change is defined when replicating ? in particular, if an update is done to an existing row, but the value is actually the same as it was originally, does this count as a change and will the replication attempt to update/resolve it or not ? I am working in a scenario wher...more >>

Hi All, Had to recreate our SQLServer instance after a rebulid of the server. Unfortuantely I was not able to recreate/reload a backup so had to create from scratch. In trying to setup replication I have the following error message trying to create a push subscriptions: SQL Server En...more >>

Windows 2003 - Microsoft Sql Server 2000 - Enterprise Edition What are all the new objects created since I started Transactional = Replication? ( I don't remember reading about these things being created in the White = Paper I have) Subscribing Database =3D New Stored procedures =3D "sp_MSD...more >>

I have a DTS package, the first step is to initalize the replication snapshop (I use sp_start_job to start snapshot job), the second step is to run another package after the replication initial synchronization is completed. How can I use sql script to verify the replicated object scripts and...more >>

HEllo!!!! Our enterprise need build a SQL server CLUSTER (4 computers).. but now we don't have resources to buy a DISK ARRAY.. My Question is : Is it possible to do this using MERGE REPLICATION between each SQL instance in each Server?. Thanks Brian...more >>

This appears to be a bug in SQL Server 2000 Replication, specifically in the "Create Publication Wizard" In Enterprse Manger right-click on the Replication\Publications folder and select "New Publication...". Select "Next", any database, transactional publication/"Next","Next" In the "Specify Art...more >>

Setup: Manually setup Log Shipping on Windows 2000 with SQL Server 2000 Standard Edition After successfully setting up Log Shipping in our lab, on the LAN, we decided to test it over the WAN, which is our goal. It took 10 hours 23 minutes to xcopy the database dump over the point to point T1 Fro...more >>

Hello, I'm using the wizard to import Data, and I can not find the option you mention. Is there any way that I can specify this option using the wizard????? Thank you in advance. Marlene A. Roman ********************** Marlene, which task did you use to import the data? If it...more >>

Hi Freinds, SQL 2000 ,WIN Adv server cluster I find out that some data is not replicating correct. I mean the specific record doesn't match in publisher and subsriber !! ( of course after replication agent has run) This happens maybe 1 out of 1000 transaction. Anybody faced this problem be...more >>

Dear Sir We have a problem in merge replication we have two subscriber on local area network that every month always lost data in subscriber or publiser we have tested again the system by dumy data and we run again the agen, so the result is the data los for information the field table not use...more >>

I am designing a web site which will use MSDE at the back end (on a remote hosting provider). Uers will be able to edit small amounts of data (in limited no. of tables) in the web application, whilst I will need to 'upload' much larger amounts (and different tables) on a daily basis My question is...more >>

i used to the sql built to remove replication,but after i remove all replication,operating table of the database still report having replication conflit.why and how to remove all replication clearly thanks....more >>

hi all, here's the situation...i have no idea what is/is not relevant, so i'm going to spit out just about anything i can. i have a sql server 2k merge publication with ~20 anonymous subscriptions (all running msde) and dynamic filters (e.g., table.fieldname = host_name()). there is also a se...more >>

I have attempted log shipping between 2 servers about 50 times now and have not been successful yet. I have followed all the white papers and get no success. The logs appear to copy to the associated shares but they do not restore onto the secondary server. The Log Shipping Monitor shows the init...more >>

Hello I made merge replication between 2 machines successfully. BUT, when a user on each machine insert a new row in the same table in the same time,the insert for the publisher wins and the insert for subscriber deleted. I need to keep the two inserts in the database. And that also happen ...more >>

Hey I'm trying to simply copy all tables from one database to another on a nightly basis. If i select the database, choose export, and go through all the steps, choosing the starting database, the destination database, the values to back up and scheduling it, it all seems fine. But the job alwa...more >>

I have a 90 Gig database on a production server and I want to replicate new data only to a SQA server and DEV server that have the same database. Both DEV and SQA groups want new data to test with on a weekly basis and they perform all DML on their copies on the Production DB. How do I set ...more >>

Dear All, while connecting the merge agent after updates in the subscriber , the following error occured 'the process could not enumerate changes at the subscriber' Any reason why this error appears? Waiting for ur feedback. Thanks in advance...more >>

Hi.. I disabled merge replication via the Ent. Mgr wizard and when I try to update a table that was previously part of the replication (either via stored proc or manually in query analyzer) I get this error Invalid object name 'dbo.sysmergearticles I am guessing that there are still s...more >>

Dear All, the subscriber database contains no longer the (upd , ins , del) triggers of the replication. How do i create them again , or do i need to drop the subscription and do it all over again. Please feedback urgently Thanks in Advance...more >>

dear all, regarding the problem of not uploading the data from the subscriber to the publisher though the merge agent is successfult and the status is no data needed to be merged. i checked the record in msmerge_contents , it doesn't exist. actually i checked with the table nick name an...more >>

Hi all I'm really a newbie at replication so I hope you can help me with a problem I've got I have a snapshot replication of a database, all tables are part of the article. Until a couple of days ago it has worked fine. But know I get error with one table (call it X), I get "The process could no...more >>

I receive the following error: "The row was not found at the Subscriber when applying the replicated command." The subscriber is RO Transactional having data pushed. The data is only being updated on the Publisher. There is DRI with cascading updates and deletes on the Publisher, with the D...more >>

Transaction log not truncating, the java program coonects to the SQL server. It working fine for certain time like (5hr after that log not truncating after the transactionlog, it keeps on growing.if i executed dbcc opentran i am getting one process was active since 3hr. this is implicit transaction...more >>

hello, I have a problem with the Merge replication. here, is the scienario : We have 3 locations , A , B and C there is a one way replication between A and B one way replication between A and C so all the data of B and C is uploaded to A.(exchange type is 1) Now the connection between...more >>

Hi if I have a backup file in a remote 'US' location of 3gb and I use getright or wget to copy this to a location in london I want to now add another location Ireland to copy this file to, will this extend the time of the copy to london if I want to copy this data to both locations at th...more >>

H I use transactional replication from SQL2000 to 50 servers running SQL7. I use pull replicatiaon and named subsribers Replication worked very good for the past 4 months, but one week ago a noticed that replication is working slower and slower.The distribution database is offcourse getting large...more >>

Hi - I'm implementing merge replication between a SQLCE 2.0 database on a PocketPC device (PPC) and a SQL 2K database on a desktop (WinXP Pro). I have an existing database in both places. I'm able to get synchronize to run, but seem to be having trouble with the conflict resolver. I'd lik...more >>