Does anyone can help to give me step by step to configure sql replication over internet....more >>

I have two tables, one table, table A, with actual information, table B with history information. table B have same structure as table A, except it have have two more fields. Each time when a record in table A inserted, deleted or updated, the record is copyed to table B, with additional ...more >>

When creating a new publication for transactional replication in Enterprise Manager, the following error message appears and the publication is not created: Error 0: This server has been disconnected. You must reconnect to perform this operation. Has anyone ever seen this error mess...more >>

Hi All I use Merge Replication . I want to Publish a subscribed DataBase from another publisher and subscribe all other LAN subscribers from this newly published subscriber . Thanks in advance...more >>

Hi everyone, Can somebody explain to me how to use the replicated data in sql server by using access as a frontend. I've made my sql server a distributor and have chosen some tables to replicate, but i don't know how to get to the data. Greetings, Lizzy ...more >>

Are solutions availible for small-med businesses to establish a standby SQL database that would allow for a remote located SQL server? The purpose is to create a fail over for either bandwidth or server failure. Most clients accessing this server are remotely over Internet. thanks, Mark...more >>

Hi All, I'm using : Win2k adv Server SqlSvr2k Sp2. One Publisher, Distributor : Merge Publication wiht Dynamic Filtering X Subcribers : Pull Subsciption to Merge Publication. I have the case that when I insert a row in Subscriber , this row first is insert on Publishe...more >>

Transaction Replication , Distribution Agent Error Detail: -------------------------------------------------------------------------= ------- ErrorMessage:The process could not bulk copy into table '"ASIEXP86"'. ErrorDetail: Unclosed quotation mark before the character string = 'A,KE...more >>

I have 18 branches (some SQL 2000 other still SQL 7) replicating (transactional replication) some statistic data to Corp SQL 7 Server. Everything was working fine for year and then yesterday I started getting errors on Distribution Agent: "SqlDumpExceptionHandler: Process (different numbers) ge...more >>

Hi, How can I or where should I go to adjust the time-out range for a replication job and its agent on sql server 2000? Many thanks. JJ...more >>

All - How often do we need to reapply initial snapshots in a Transactional replication? How much time does SQL Server takes to apply the initial snapshot, say if I have a 100 MB, a 500 MB and a 1 GB database, each separately? Thanks - Scott...more >>

Background: 1) SQL 2K SP 3 running on Win2K Servers 2) Original Snapshot Created via DTS Export from Publisher to Subscriber 3) Subscriber is 'primed' via script for removal of certain defaults, identity columns etc. The problem. I have certain tables that have Identity-Insert OFF on...more >>

NOTE: A system table hack included within this solution ... Environment: - Merge publication that allows anonymous subscriptions. Dynamically filtered. If you attempt to: exec sp_dropmergearticle @publication = 'NAME', @article = 'NAME', @force_invalidate_snapshot = 0 You're greeted wi...more >>

Hello everybody, Sorry for the crosspost, but I think I picked the right groups. Also, I apologize in advance for the length, but want to maximize the amount of information you have before you attempt helping me. I am new to OLAP & replication, familiar with DTS (although have poor luck with ...more >>

I am getting error 20598 in transactional replication The row was not found at the Subscriber when applying the replicated command. {CALL sp_MSupd_tblAcct (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,791.0500,NULL,NULL ,NULL,'17360906-1',0x0001)} It seems that the primary key value is missing(...more >>

Hi All, Our network runs a publisher A, Distributor B and a number of push subscriptions to many subscribers. All Running SQL 2000 SP2 on Windows 2000 Server SP 3. Merge Replication I keep receiving the error " The process could not query row metadata at the subscriber" I realise that...more >>

I have a VB application which is based on an Access dB which is replicated to many remote sites. I am looking into switching to an SQL Server solution and want to know if every remote location with a replica will need an SQL server license? Also, with Access, the Access .mdb file can be ...more >>

Hi All I use Merge replication for replicating between SQL Servers .What is the actual way of replicating data between two publishers . Regards Prasanth.B...more >>

Hello: Is possible to create the subscription on the server (distributor and publicator) detach the database, send this database to the client (via email or ftp), attach it and then synchronize? I need do this becouse the database has a lot of data and takes more than an hour create the ...more >>

I am using sql server 2000 transactional replication. i want to change datatype of column in the published artcles. is there any way withou dropping replication. Thanks BIJU...more >>

i am trying to set up transactional replication from windows 2003 sql server 2000 to sql server 7 and Log Reader agent keeps getting error "An access violation occured" please help. ...more >>

Hi all, This is my current architecture. SQL Server 2000 SP3 on Windows 2000 Server I have 2 publications on my main server, both are transactional replications The 1st publication defines tables that are not altered at the subscriber. The 2nd publication (queued updating) defines tables th...more >>

SQL 2000 Transact Replication with immediate updating of subscribers. I can modify the publisher's user tables, but any of the subscriber tables give me an error message that "login fails for user 'sa'" even though i'm logged in as 'sa' so i know that the login works. weird... Don ...more >>

GOAL: Create anonymous merge pull subscription initiated via VB6 code calling methods of the ActiveX component SQLMerge (MS Jet and Replication 2.6 Library). The article at http://www.588188.com/netbook/sqlserver2000/replprog/progre plactivex_2y0c.htm explains that this is possible. Curr...more >>

I've started and stopped replication successfully several times. This time, however, I'm getting the following error message when it tries to do the initial snapshot bulk copy. Can anybody please help... The process could not bulk copy out of table ... I/O error while writing BCP dat...more >>

Hi I have just set up a simple transactional replication between server A and Server B. I did all the work on Server A, setting up the distribution db there, and Server A acts as a Publisher, pushing out DB data to subscriber B. The initial set up was that snapshot to be run so the subs...more >>

Hi I have a transactional pull subscription. After the 336 hours it expires, and I would really like to stop this happening as I'm otherwise going to have to write code to trap this if it occurs, and reinitialise the subscription. Does anyone know how to stop this occuring? I'd hoped the fo...more >>

Hi, I am using Merge Replication for synchronization of data between two SQL 2000 servers. The tables are divided into different logical groups and I want synchronization to happen at these group levels i.e. in case of failure in synchronization of one table, entire group of tables shou...more >>

Hi, I am running sql 2000 server. I have replication jobs running on my distribution server. It happened quite a few times now that the subscriber agent times out and shut down itself, and I would have to manually restart the agent. What caused this to happen often? Many thanks. ...more >>

Hi, Is snapshot replication will the whole database including user, roles, and stored procedure? If I just want to replicate the data, which function is the best way to use? I have the situration -- 1) the source database was connected by users most of time, so I can't use copy databa...more >>

A client upgraded thier SQL server from SP1 to SP3 and had the server set up as a publisher and distributor a push publication on a database. After the upgrade all of the replication agents as well as the database publication are giving the following error: Cannot load the DLL replincreme...more >>

Hello, I'd like to drop a column from a table in my database. When trying to delete this colum; I got the error message: ALTER TABLE DROP COLUMN failed because 'rowguid' is currently replicated. The table was replicated a while ago but isn't anymore. My guess is that when we disabled th...more >>

Hi All Over the weekend, I copied a a published database from one server to another using the detach / attach approach. Once I had attached the database I ran *sp_removedbreplication* to remove the publications from the database. This all worked fine, the problem that I have now is that the da...more >>

Hello Group, I have setup a Merge Replication between two servers. (SERVER_PUBLISH is the Publisher and SERVER_SUBSCRIBE is the Subscriber). I was periodically getting Network errors, I tried looping step 3 (both on success and failure) of the job back to step 1. I have also gi...more >>

Hi, I am aware that the context info (SET CONTEXT_INFO) is valid for only the connection and to be retrieved, has to be read from the master.dbo.sysprocesses table using the query : SELECT context_info FROM master.dbo.sysprocesses WHERE spid = @@spid But, does SQL Server support it'...more >>

I have a problem that a single database keeps getting a timeout error. I have 4 other databases that are replicating between these 2 servers that are working fine. However, this single database keeps timing out. This database does have more activity than the others, and network issues s...more >>

Hi everybody i've been working in my replication sceneario for 3 weeks, so suddenly appear this error when i re-setup and publication owe a schema change in the database involved, the error is asociated to the distribution agent! Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__46D4D...more >>