Hi All, I currently use the SQL Merge ActiveX control to perform synchronization from my application. In SQL Enterprise Manager, you can configure the Merge Agent Parameters (-KeepMessageAliveInterval, -QueryTimeout, etc.), but you can also do this from the ActiveX control. My question is...more >>

Hi all, In my production environment, there is a source database that replicates data to another server (using transactional replication). Because of some upgrade needs, I need to change the subscriber database to store Unicode. As a result, I want to customize the replication such that our ...more >>

I have one publisher & two replica servers one of the replica server has gone down. Here the question is do I need to create the publication again or just I need to enable the subscribtion on the failed replica server. Thanks ARR ...more >>

I have been having this problem for ages now and i dont know where i am going wrong!!!I am running the following NorthwindCE sample http://samples.gotdotnet.com/quickstart/CompactFramework/doc/sqlcemergereplication.aspx and i am getting the following error "Message: Some Distributor properties a...more >>

I am trying to set up merge replication between windows sql 2000 and msde clients. I was wondering if anyone has sucessfully done this and would be would be willing to share his experiences and approcah with me? I would be obliged if someone could point me to a resource which would cover al...more >>

Hello, I have a Merge Replication setup between a publisher and a subscriber. About a month ago the replication failed. We have recently reconfigured the replication(recreated the publications, distributors, and each of the subscribers) and got it all going fine now, no errors. My is...more >>

Hi guys, I have a problemo - basically i have one large SQL2000 DB. This is edited / updated etc by users of the website i am developing. However i also wasnt a SQLCE component as i want certain users to recieve user-specific information from the database to their PPC's (I don't have access to ...more >>

I have a table that is being used in transactional replication. On publisher side table is altered and a column is added. I would want the new column also to be replicated. Here is what i did- - drop the subscription - remove article from publication - add back article - modify insert upd...more >>

Hi, I am changing the scenario of our replication from Push to Pull, but I could not set up the Pull replication. The publisher and distributor are on the same machine. The subscriber always gets an error message as "The process could not read file "E:\repl\unc\MyServer_MyDB\200508\tableone.sc...more >>

How can I run the snapshot agent of a publication from within a custom job in one step? I have a snapshot publication that will execute on demand. A custom job will initiate this process, but the custom job needs to be able to wait until the snapshot agent is finished as it will do many oth...more >>

How can I run the snapshot agent of a publication from within a custom job in one step? I have a snapshot publication that will execute on demand. A custom job will initiate this process, but the custom job needs to be able to wait until the snapshot agent is finished as it will do many oth...more >>

Transactional Replication - SQL 2000 - remote distributor Have publication replicating 300 tables and I want to add 1 table. sp_addarticle adds to publication, how do I add to each subscription (4)? Can add schema to subscribers - new table so no rows exist anywhere. How to add to subs i...more >>

How do you Migrate Merge Agent Subscribers? or do we have to Orphan all obsolete, defunct Replicas? OK; thanks for your help. We got our Database Published, and 30+ Anonymous Subscribers have been happily doing bidirectional Internet updates for over a month, with an Access Runtime Project....more >>

I plan to set up merge replication and have laptops with an MSDE subscription for replication. I want my application to use the database name and wondered if I can (and should?) have the same database name on both the laptop and the main publication. Thanks. David ...more >>

i have setup replication that works fine, after adding some article while applying changes, my db went to suspect mode, by running following script Sp_configure "allow updates", 1 go Reconfigure with override GO Update sysdatabases set status = 32768 where name = 'criticaldevices' ...more >>

Hello, I created a stored procedure that renames a table to OLD_xxxxx and replaces that table with another (copy) that resides on a different database. I pull the tablename names through the use of a cursor table and construct a SELECT INTO statement as follows 'SELECT * INTO DB1.dbo.'...more >>

SQL 2K I am attempting to create a transformation for a transactional publication following the documentation @ http://msdn.microsoft.com/library/default.asp?url=/library/en- us/howtosql/ht_replctem_36p5.asp When I click on finish, the wizard gets to the step 'Adding task 1 of 1', then I...more >>

We have started getting the following in the application event log: Error: 823, Severity: 24, State: 2 I/O error (torn page) detected during read at offset 0x00000015ba000 in file 'd:\sqldata\MSSQL\Data\distribution.MDF'. and is being generated during distribution cleanup. We have NO backup ...more >>

While creating the initial snapshot on a Transactional Replication job I will receive the following error message. It does not always happen on the same table in my database, but it is always the same error. I have 2 separate SQL 2000 machines both with SP4 installed. the MDAC Versions are t...more >>

Can a subscription of a snapshot publication containing 2 or more articles choose which articles it wants? For example, if the publication has 5 articles published, and the subscriber only wants 3 of them, can the subscriber specify the 3 or does it have to take all 5? I know this cannot be...more >>

I was setting up transactional replication for a big table and got the following error message: The article cannot be created on table 'TEST' because it has more than 255 columns Is that the limit of replication in SQL Server 2000? If yes, Is there any way to increase the limit, or it ca...more >>

Hello, I am having trouble getting the indexes and primary keys copied to the subscriber in a snapshot publication. I created a snapshot publication and added an article to it using the wizard. Then I used the SQL Management Studio to configure the properties of the article and set the foll...more >>

Hi all I need to copy a user database from disk E to disk G using the 'attach and detach' and then take that disk to another server where i will attach the database. Do i also have to copy the systems databases (Master, MSDB, Model)? How do i also keep the logins and security features that...more >>

Hi I have setup transaction replication, I defined publisher. Now I have new server Where I run create script for database and table from publisher server. First time on my subscriber server's table has rows, I can’t restore from backup because of time (it took about 8 hrs. to restore)....more >>

Our SQl Server 2000 was rebooted recently but when I check the management section then jobs replication its registered as failed yet when checking the history it is still executing step 2. Yet when I check in the replication monitor in the distribution agents replication is as normal do you k...more >>

Hi all, Here is a challenge - and I'm loosing ... I'm trying to get a push subscription to work to an Access mdb file from SQLServer. I get the following message when running the Merge Agent: 'S:\network\share\access.mdb' is not a valid path. Make sure that the path name is spelled co...more >>

Hello, We plan to establish a merge replication topology in which several servers (subscribers) have "public" data – data that have to be propagated to the other servers, and private data - data reside only at original servers. Private and public data are marked with one table column (1/0...more >>

Hi All, I have 2 database servers and it had been replicated with transactional replication model but the replication was stop for some reason for months. The error message was on subscription agent and I deleted the pull subscription then I re-created it with out initializing schema becau...more >>

We've had replication running for a while. We had some hardware failures last week and had to restore an old database from before the failure. Now we have some tables that are replicating correctly but others aren't (using merge replication). We've made changes to the data, seen the data get ...more >>

Hello, What problems can I expect to find (if any) when renaming a table after a snapshot publication is applied? I would like to know how will the indexes, transaction log, foreign keys, etc. be affected by this rename, it will be done on a daily basis for a table that consists of 20-30 mi...more >>

Guys , I need your suggestions about which SQL Server monitoring tool I should select. I have been eveluating IDERA's DM and I kind of linking it. But at the same time I hear about few other tools in industry and I need some expert's openion on these tools. The other product I am sugge...more >>

I have a SQL Server 2000 installation on Windows 2000 Server, last night I updated this server with SQL SP4. The install was successful but after the installation one of my Publications failed with Data Transformation (DTS) Failed. In the Event log I have the following error. Microsoft SQ...more >>

Hi, One of the replication topologies is "Central publisher with remote distributor" as Alexander Chigrik mentioned in the article "http://www.mssqlcity.com/Articles/Replic/SetupMR/SetupMR.htm#part_1" My question is, is it possible for merge replication that an anonymous subscriber synch o...more >>

Hello, I would like to find out how are foreign keys handled when a snapshot is applied to a table that is referenced by many other tables. What happens under the hood in this situation? Since the snapshot will first drop the table and then re-create it, will the foreign keys referencing th...more >>

125Gb heavy OLTP publication db w/ Transactional Replication replicating 400 tables to 5 different servers. No problems on remote distributor, cpu hardly used, sits practically idle most of the day staying under 10%. Ram is used however not getting taxed. We added merge replication for 1 ...more >>

While attempting to enable replication on a customer's SQL Server cluster we encountered an error during the execution of the distributor Install() method. The error is "This server has been disconnected. You must reconnect to perform this operation." SQLDMO is used to create the da...more >>

I am relatively new to SQL Replication and am trying to configure replication for some SQL databases for a disaster recovery project. I have several databases ranging from 100MB to 5.5GB that I want to replicate to another server offsite. I am starting with a small database. I go through th...more >>

About a month ago I setup a Server and named it SQL1 I setup a maintenance plan and all was well. I needed to rename server to SQL. I went onto the server today to take a look around and noticed that the DB is 133GB instead of 35GB. When I when to make some changed on the maintenance plan I go...more >>

Hi Freinds, SQL 2000 I have a transactional replication which seems to be fine and replicating everything, all agents looks healty too. but I have the red cross sign under agetns > distribution agetns , but the agent itself is green. I didn't notice any problem at replication and looks fi...more >>

FYI - I know basically next to nothing about replication. We have production servers that are located in a secure location entirely separate from our own location and networkd. We want to set up a hot-copy that is, at most, a few minutes behind production but that would be located in our own o...more >>

I have a replicated database and hundreds of records keep "disappearing" from one table in particular. The table is a child table storing the answers to a number of questions. Also; 1. The tables have referential integrity enforced, with cascade delete. 2. The relationships are enforced for ...more >>

Hi All, I am asked to set up snapshot replication for our company and I would like to get best practice / or solution to go for it. The followings are the requirements and specifications. We have 4 different companies in 4 different location and one head office. All 4 companies and head...more >>

I have a problem where inserts into a table that is part of an indexed view are failing (with a Cannot insert duplicate in the indexed view's unique index error) but the inserted record is not a duplicate according to the unique index on the indexed view. The indexed view is a select joinin...more >>