We have a website that displays information from a SQL 2K DB (A). This DB gets its data once or twice a day from a batch job that locks up the tables for 10-15 mts within a transaction. The number of rows inserted/deleted/updated within this job is not huge (5000 to 10000 rows). Because the ta...more >>

I have an application using SQL Server 2000 and Delphi for the front end. I have 2 SQL Server, on each side of a WAN and 15 offline users with Laptops that sync using Merge replication. This app has been running for about 6 months now. Lately, I am getting a few conflicts saying that the r...more >>

Hello, I am trying to add a new column to a table that is being replicated. I want the column to be varchar 5 and have a default of YES. The script below seems to error out. sp_repladdcolumn 'DOOR','ThisIsDoor',varchar(5) DEFAULT='YES','MergeAllDoors' Thanks, niv...more >>

I cannot delete a database becuase it ways its part of replication. I removed replication via the EM GUI but it failed. All GUI elements are gone but when I run sp_removedbreplication in query analyzer I get this: Server: Msg 3701, Level 11, State 5, Line 1 Cannot drop the table 'HesstechUser....more >>

I am a software developer who has been tasked with setting up replication for one of our clients. I have about 1 week of experience working with replication, so any help would be appreciated. My situation: 5 databases: Production - All sales transactions go into here Corporate - Used to report...more >>

I am creating a SQL table from a couple of different sources. The first data source is an Excel spreadsheet. The spreadsheet tracks all the attributes of LOTs (description, location, seller, a unique LotNum, etc.) This spreadsheet is historical - that is, it includes records for LOTs that hav...more >>

[replication via Internet] A) What is the preferred method to "prep" a computer for replication prior to deploying it in the field? I prefer not to push the database along with the subscription over the internet. B) After it has been deployed and functioning properly, what is the best ...more >>

I have a laptop on a LAN and I have pushed a new subscription to it. Now I want to move the Laptop to its proper location (in another city for example) and replicate to it via the internet. Can I simply edit the server registration at the Publisher? thank you, bob ...more >>

Hello, Can you remove replication while the publisher to be removed is in use or will that cause problems? Any help would be greatly appreciated! Thanks in advance....more >>

I have a database I wish to replicate, therefore i have set up a transactional log replication.. But now when I add a row on the main database, this is NOT replicated to the subscriber... Then I inizilize a snapshot, (this will drop table and replicate all agian) the row still do not com...more >>

Hi, I am using the default conflict resolver given by sql server 2000 (datetime(later wins)) for resolving conflicts in merge replication. For all the conflicts resolved by this resolver, there is no record of the conflicts in the conflict table. Is there a way one could keep the records when s...more >>

Hi there Maybe Im missing something but.. I have a order tracking system running on sales peoples laptop's. When they connect to the company Network (via dialup) at Night I want to push all off there orders to a named SQL, and then remove those orders from their own laptop. So in a sense, Its...more >>

Hallo, can someone explain this problem/suggest a solution I made server A publisher and server B distributor. On server A I had a database base1 which had a size of 70 GB and contains 1200 tables. I restored a backup of that database on server B. I made a publication on server A for database ...more >>

Hi, I'am rather new in the subjects "replication". Is there anybody existent who has much experience and can give me some information (or links or whatever), where I can find information (or samples) for SQLServer replication which provide more information than the on-line-help. We have to es...more >>

I have an ETL process setup in my OLAP stagging area for a particular reporting application. The stagging area consists of articles from several publishers. I have a two step external process that runs, the first step updates the status of detail items in each publication, the second step synchr...more >>

Hello. I'm setting up a Push subscription. The articles of comprised of tables, views, and stored procedure. The Snapshot agent finishes successfully and then the Distribution agent kicks in. I'm getting the following error: Insert Error: Column name or number of supplied values does not ...more >>

Hi all, How can I run a script after the snapshot agent execution has complete. Marius ...more >>

hello, i have on error for the configurepublishing and subscribers the error message was: SQL Server Enterprise Manager could not complete the wizard because @@SERVERNAME for '' is null. Use sp_addserver to set @@SERVERNAME. but it on the query analyze type the command to view my @@SE...more >>

I'd like to detatch a database but I am told the following: ATTENTION:the database cannot be detached while it is being replicated. I was going to stop the replication but when I look in the 'Replication' node in Enterprise Manager for that server there are no Publications or Subscriptions l...more >>

We have a 10 GB production database that is currently being replicated (transactional) to a remote location connected by T1. Needless to say we would like to avoid having to reinitialize because the process over the T1 takes over 24 hours. In the publication properties we have subscriptions set t...more >>

Hello, When I try to remove/disable replication on a particular server nothing happens. The message box 'Removing publishing and distribution components ...' comes up and just hangs from there on. Does anyone know why this is happening? Any help would be greatly appreciated! Thanks ...more >>

Hi, I have configured transactional replication with one publisher and one subscriber. after completion of schema and bcp operation , it has given message as "posting commands into the distribution database" after that timedout expired . Now the error message is "The concurrent snapshot f...more >>

Hi, I have an Access database that has been replicated over an intranet. It is a fairly simple database - it has people working on it online and people who work offline and sync into it. Now we need to sync over the internet. I enquired in these discussion groups and was adviced to Upsize my d...more >>

Hi, In a published database (with 2 Merge / Subscribers) i change the ID-Range (Automatically assign...) from the publisher and the subscriber from "10" to "50". After the changes i start the the snapshot new an restart also the merge agents. Then i try to create more then 10 entries and b...more >>

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2) We have configured SQL Merge replication with one publisher , one subscriber in two different serve...more >>

Hi, I have been trying to create a publication of all my views in my database. The problem that i have, when the subscriber tries to apply the snapshot is that some views are dependent to others views... so, the subscriber fails (because the dependency has not been created yet). This is h...more >>

This is a very odd error I am getting when trying to do an update on one of the tables in the replication. The only place I can find @c69o is in the trigger created by the replication wizzard and the variable does seem to be declared. The table has 180 columns and other tables in the replication u...more >>

I am getting the following errors while applying my intial snapshot. 1) Error_Code: Error_text: select * from "FBCO070" where 1 = 2 2) Error_Code: S1010 Error_text: Function sequence error 3) Error_Code: 2627 Error_text: Violation of PRIMARY KEY constraint 'PK_FBES010'. Cannot insert d...more >>

I have several articles in a SQL Server 2000 merge publication where I need to do one of the following: 1. Delete a existing key and its column, and create a new one with a new column. 2. Add a new key using existing columns. 3. Add a new key using a new column to be added. Since this...more >>

Hi I was wondering if anybody had seen this problem before. I have to Windows 2000 machines both running SQL 2000 Enterprise Edition with SP3. I am trying to log ship 4 Databases from the primary to the secandary. The Databases that I want the logs shipped to on the secandary server ar...more >>

Does anybody know if it is possible to make a merge replication between two instances of SQL Server in the same computer??? ...more >>

Hi, sometimes (often) my merge replication agent hang on this step: Processing article 'table1'... or (occasionally): The merge process is cleaning up meta data in database 'db1'.... table1 is a large table (22 fields, approx 400.000 rows) with no Primary Key. I don't have any idea with 'met...more >>

Hi, I have allocated 35gb for Tempdb and nearly 200gb free space is there for that particular drive , residing tempdb, automatic growth is enabled and free space for tempdb is showing 34GB. But some times i am getting error as "Could not allocate new page for database 'TEMPDB'. There are no m...more >>

I am trying to setup a process in a VB.Net app that allows the user to manually invoke a transactional replication process. This works fine on my development machine within our network/VPN. However, when I disconnect my machine from the VPN, the process keeps failing with a "Process could not conn...more >>

Hello, I'm setting up an SQL Operator for noticing me by mail if replication doesn't work. Everything goes fine until i'm trying to test the operator; test is ok but emails remain stuck in outlooks outbox! If I'm starting Outlook all the test emails are sent correctly. So, what must I configure ...more >>

Hi guys, In my lodg shipping setup i selected the option terminate users in database. but if the database is open the restore is failing with following error. [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3101: [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not b...more >>

Dear all, I'm confuse knowing that some rows didn't replicated to subscriber. No error, no message, no idea at all. Is there any workaround to do? I'm not sure to have resnapshot because of the large data and long distance site. I'm using simple merge replication. No filter or any modified thin...more >>

os : windows2000 server language : korean sql : sql2000 enterprise edition i have two sql server(devsrv and parkchangsoon) i configured the transaction replication parkchangsoon : publisher,distributer devsrv : subscriber articles are 10 of all tables and 10 of all procedures at first ...more >>

i create the subscription and replications ok . and the sql 2000 have three step.. one step, it is create the snatspot,it is ok two step, it is create the log agent processing..., it is ...error and have below message such as: The process could not execute 'sp_replcmds' on............... ...more >>

We are using SQL Server 2000 merge replication and have a publisher with three remote subscribers. Everything has been working well for a year but there is a problem with a newly published table article. The table has a primary key with the Not For Replication option set. However, the publisher ...more >>

Hi, I am trying to setup a replication between two SQL 7 SP4 Standard Edition and I am confused if this can be done or not. Is anyone here that done this and guide me through the process? I need a way to have a solution for standby database of site that is keept in a consistent state. I a...more >>

Scenario is: Publisher database on 16way/8gb box, distributor on 4way/4GB (standalone), 7 subscribers (used as reporting - not updateable), continuous transactional replication. The storage is a new EMC DMX3000. During working hours, the latency increases almost continually to a point that it ...more >>

I don't know how I can make the merge replication or RDA (push - pop) whit SQL Server CE and MSDE. Can you give me samples? thanks Damiano ...more >>

Does the 255 column limitation exist still when doing transactional replication with SQL Server 2000? Thanks!...more >>

Here is the error message that I'm getting. I'm setting up a remote distributor and trying to create a publication at another server: The name of the database that I want to replicate is "SAM". I'm trying to set up transactional repl: "SQL Server Enterprise Manager could not enable database 'S...more >>

Hi, I removed a publication using the enterprise manager, and it has gone from the publications views, but i can make the db ofline, because it reports it is still published. What can i do to tidy this up??? Thanks -- Duncan ...more >>

Hi, Before I ask for input, I just want to thank everyone in this newsgroup for being so helpful... I've really gotten through some complicated issues thanks to the information here. People like Hilary are always coming through. I am deploying a solution that depends on Continuous Merge Pu...more >>

I am trying to use immediate updating transactional replication. A few of the tables have text fields. I want to filter out these fields, but when the subscriber reinitializes I get a bcp error - unexpected EOF. When I switch the publisher to use character format (rather than native) I get an unk...more >>

Hi all, Is it possible to replicate just a portion of the database (everyday) using snapshot replication? If so how can it be done? Just FYI, my Publisher, Distributor and Subscriber are on the same SQL server. Thanks in advance for any help John...more >>

Hi everybody; I try implementation a transactional replication system with SSL over Internet, pull anonymus suscribers (MSDE) and FTP for Snapshot. But I have some cuestiones with the security and others issues for this options. 1) For the snapshot I use FTP in the distribuitor server, b...more >>

I am trying to run a script that is attempting to insert about 5000 rows into a table, approx 5000 into a second, and probably about 150000 into a 3rd table. All 3 tables are being replicated, and al 3 have identity ranges set around the 100,000,000 mark. Trouble is when i run the script to...more >>

I have a merge replication setup. for simplicities sake lets say the publication has 4 articles(tables). The publishing database has 6 articles(tables). All 6 tables exist both at the publisher and subscriber from previous repl setups. I make the publcation with the 4 articles... create the new ...more >>

copy/past of sample error: ------------------- Warning: only Subscribers running SQL Server 2000 can synchronize with publication 'mytestdb' because schema replication is performed. Warning: The table 'GeneralInventory' has been created but its maximum row size (9929) exceeds the maximum numb...more >>

Hello All - When trying to restore the publication database, I am losing the publication! ( Running merge replication, SQL Server 2000, push subscriptions). I am using the RESTORE command as follows: RESTORE DATABASE CDB FROM DISK = 'c:\temp\somefile.bu' WITH KEEP_REPLICA...more >>

Dear Friends I want to Create the Transactional Replication with the MSDE database Kindly suggest if the same is possible. Your earlier reply would be a great help. Best regards Sharad ...more >>

Can anyone tell me how I can copy from the Production database to the test database? Thanks...more >>

Hi group, sorry for my question but im even not so confirm with replication. We are using a merge Replikation and i also choce Stored Procedure within the Replikation. But i changes the Stored Procedure at the Publisher and Start a Pull but the changes didn`t reach the subscriber. Is t...more >>

I would welcome views and advice on replication please. We have a central database (SQL Server 7). This is fed with inserts and updates (not deletes) from a remote database (SQL Server 7), which is updated by remote sites. Any insertions or updates (again not deletions) on the central database ...more >>

Hi... I see that there are activeX controls for Snapshot and Merge replication...but I cannot find one for Transactional replication. Does this not exist? And....if not...what are my options for starting an existing subscripton (anonymous pull)? SQL DMO? If SQL DMO....can anyone point out som...more >>