How and when are the sync_xxxxxxxxxx objects used ? I see them on the publisher and wondering the use of them ...more >>

Using trans replication and I believe by default all the clustered and non clustered indexes are copied to the subscriber .. Can someone confirm ? ...more >>

As part of transactional replication, are there cases when triggers created ? I know custom sprocs are created in default trans repl and additional column is created for updatable subscriptions.. but not too sure about triggers .. ...more >>

Ive been trying to grasp on transformable subscriptions and let me know if this works.. Say i have a published TableA with data such as Col1 Col2 Col3 1 A B 2 C D 3 E F 4 G ...more >>

I have 1 production db and 1 subscriber db using transaction replication on SQL Server 2000 standard edition. They are over 100 gb in size. Essentially the subscriber is a hot backup for the the production server. The db was restored manually at the subscriber because it is to large for snapshot....more >>

In effort to split out the reporting feature on our SITE we have been testing various replication scenarios. We have found that in a clustering environment a transactional replication was recommended as about the only solution. During high usage the disk Queue and disk writes max out at a soli...more >>

I've have seen a bit of information advising not to replicate text, ntext, & image datatypes. Can anyone speak to real experiences of this, either good or bad? TIA ...more >>

I have two way transactional replication between Hq and other partner countries. I want to create same enviornment in a lab for testing for upgrade from SQL7.0 to 2000. Transactional replication is replicating same tables and same rows and columns both ways;subscriptions are not updatble. ...more >>

Hi all, Is there a way to check the subscriber if a particular subscription exists using SQLDMO ActiveX control? If not, how would it be done through stored procedure? -- Thanks, Tom...more >>

I know it is possible to have one article merge to a different column name: Is it possible to have different table names and different column names merging? One DB will pull from the other but will not merge back Thanks, Rob ...more >>

Hi, I have and snapshot replication. When i synchronize it (in SQL server enterprise manager right click Subscription, select starts synchronized), there is an message: "No replicated transactions are available". What does it means ? Ly Hoang Hai ...more >>

Using transactional replication with updatable subscribers on Sql 2000 Server SP3a. I have server A as the Distributor/Publisher and Server B is the subscriber (both are QUAD cpu machines). I keep getting this error message when starting the Snapshot agent to run the initial snaphot for the pub...more >>

I have been working on a customized version of Log shipping and have a need to run a nightly job that updates the standby server's msdb job tables to keep the primary server's changes. Has anyone come up with any scritps to handle something similar to this?...more >>

I'm trying to configure my SQLServer 2000 sp3 developer edition as distributor. I used the wizard and during the process, after creating the distribution database, I receive the followin error: SQLServer Enterprise Manager could not configure 'SVR1' as the distributor for 'SVR1'. Error 14113: ...more >>

Im setting up log shipping between two registered servers, and I get error message Error 14261: The specified primary_server_name.primary_database_name ('N') already exists. Error 14426: A log shipping monitor is already defined (...). I took a look at the bug report http://support.micro...more >>

Hi, In our database a job is scheduled to run at 6:30 PM. I need to run that job twice a day ie., at 12:30 PM & 6:30 PM Is it possible? Is there any alternative for this without creating a new job? Thanks, Soura...more >>

Hi, I have 20 databases in merge replication between local & remote server. I need the date & time to know when that particular change is replicated. is it possible? & what is use of the column rowguid can we get any information from this? Thanks, Soura...more >>

Dear All, We have two servers, Server1 and Server2. Server1 has four transactional publications to Server2. Server2 has the Subscribers and the distributer. None of our replications are working. In server1 when I stopped and restarted the replication for a database I had the error 'Error 208...more >>

In another thread I noticed that Hilary mentioned Double-Take. I had forgotten about this product. I am curious if Double-Take would be a better solution for a standby server, as wouldn't it replicate both ddl an dml data? Anyone know aproximate cost of this product for a 2 server envi...more >>

I am having a bit of trouble with some of our Publications. There are 8 of our overseas servers that normally replicate a copy of there database back to a server at head office. The problem is that they are failing to connect to the distributor stating a general network error. Where I am havin...more >>

I have searched through this NG as well as searched BOL concerning this process called Automatic Range Management, which is suggested as an easy way to handle reseeding of the identity values. But I have no idea how to set up ARM. I looked through the properties of my publications and subscr...more >>

What is replication in sqlserver and where it is used,and how can i configure/use it. And what is publication and subscription. -- dijas...more >>

Has anyone tried to do replication or log shipping on the same server? The reason being I need a replica copy to server the reporting service so that heavy loaded queries won't impact the online processing. Thanks for any advice....more >>

I have set up snapshot replication between two SQL 2000 Servers. I created the database UKDB on the second server, and published everything about the UKDB database from the first server to the second. The snapshot builds and creates 278 articles. But when the push runs it stops at one of t...more >>

is this a bad idea? I have a sql person here that said to change that settings for "could not execute 'sp_replcmds' on" error. This is a pretty busy db. The query time out is set for 1000. I have seen this suggestion from both hilary and paul. I am afraid about keeping this read batch s...more >>

All, Does anyone know if there is a way to set the default schedules for the various replication agents. For example, whenever I create a publication/subscription I don't want any schedule on the snapshot agent, Monday - Friday 12:00AM - 11:59PM every 5 minutes for the log readers etc. ...more >>

I have a snapshot publication, which does not seem to be moving the data. I only move data for the previous day. The snapshot agent runs, and creates the .bcp file. I check the MSsnapshot_history table, and the snapshot completes successfully, and the commands are posted to the distribution d...more >>

Hi, I have two datatransfer speed problems with inserts,delets and updates of a replicated database. The replicated database is a mergepublisher with two subscribers. When I import data with dts, I have a transfer speed of 5 rows/sec. How can I increase this speed ? When the import is re...more >>

I am busy designing a syestem that will ultimately consolidate data for franchisees into a reporting database. The easy part is that most of the franchisee databases are in our hosted environment and accessed by the clients via Citrix. That means we have immediate access to their data and gr...more >>

Hello, i use MSDE and try to setup a merge replication. I want to drop the replicated db, but get some error. Sorry for the german error msg: 1> sp_helpdistributor 2> go distributor distribution database directory account min distrib retention m...more >>

Hi, I've a replication in a SQL Server 2000 to syncronize with a SQL CE 2.0. When I try to update a row, I get this error: Invalid object name 'ctsv_F9F22D34FACE4A1BA4D2B061ADBEE5C1' I get this error if I try to modify a row from enterprise manager too! Can you help me please? Thanks!...more >>

Hello, we have 2 identical system that use a MSDE as DB Engine. The second system is a pure "warmup system" that normaly only monitor and is readonly as long as the main system is running. Periodlly (all 30-60sec) some new values (3-4) get insert into the DB on the main system. The DB is arro...more >>

Most of the ins,upd and del have 2 sproc definitions for each articles such as create procedure "sp_MSdel_Region" @pkc1 int as delete "Region" where "RegionID" = @pkc1 if @@rowcount = 0 if @@microsoftversion>0x07320000 exec sp_MSreplraiserror 20598 GO create procedure "sp_MSdel_Re...more >>

Is it possible to replicate tables that have text and image datatypes ? Using transactional replication in SQL 2K ...more >>

I am currently trying to setup Transformation on a Transactional Publication. When When I finish setting up all the transformation for the package and click finish to save the DTS package I get the Message "SQL Server Enterprise manager could not complete this operation." this message comes ...more >>

Environment: SQL 2000 SP3a, Windows 2003 I had one database called RepPublisher and it had 3 transactional replication set up based on group of articles. After that I dropped publications on this DB and dropped the database altogether. Here is the miracle part: I recreated a brand new d...more >>

I am looking for some sample code using SQLDMO for replication (merge and transactional) with SQL Server 2000 written in C#. Please help. -- Thanks, Tom...more >>

This is the message that has been displaying from my distribution agent for the last two hours!! Funny thing is, according to the log reader, there are no replicated transactions available. Also, when I run sp_repltrans, i get NO rows back..... What is going on?!?! Any help would be app...more >>

I'm trying to track down some errors I'm encountering when generating and applying an initial snapshot that consists totally of stored procedures. I have the distribution agent set up to log errors and then continue on - skipping the error. What I am unable to glean from the ms_replerrors tab...more >>

I have a snapshot agent that I cannot get rid of. The publication did not exist, so I went into distribution.MSsnapshot_agents table and delete it. When I refresh the snapshot agents folder, it is gone. At some point, the damn thing gets recreated. What is recreating this agent? How can I ...more >>

Hi, Is there any direct way to start snapshot agent as soon as there is a chnage in schema at Publisher's database? I don't to run it manually and/or schedule it to run at a specific time .... KP...more >>

We have an installation of various SQL Servers, all with the same data base, that replicate among them by means of a star distribution. The problem is that at the moment of the creation of the replica some foreign keys of the database were not defined. After defining these foreign keys in all...more >>

Hi All, I have set up a snapshot replication, and schedule it to run every night. The snapshot run successfully, and data get replicated to the subscribed server. However, data do not get transfer as the second day and there after. I check the job history, the job (distribution) run success...more >>

Do updatable subscriptions such as immediate and queued create additional columns on the publishing or subscribing tables in a trans replication ? Using SQL 2K ...more >>

The merge replication running continuously between two servers (sql server 7.0) on a 100MB database with 300 tables. The transaction log size grows to more than 100MB every hour, even though there are no data changes. Is this normal? ...more >>

Hello everybody: I'm having trouble with bidirectional replication. This is the case: As an introduction i'm implementig a transactional replication and I have 2 Servers called A and B, and i made a tabled called Table 1 with 2 fields number int key and Name nvarchar(50). I modified the ...more >>

I have Transactional Replication set up in unidirection where subscribers are getting read only data. Articles dont have any horizontal and vertical partitioning either. The problem is even though there are transactions taking place in Publisher, distribution agent is sitting idle and not repl...more >>