I am trying to create the initial database from a snapshot on my SHED1 MS SQL server. Whenever I run the code below, I get the following error: 'The subscription to publication 'SteelPMOSql1' has expired or does not exist' When I installed MSDE 2000, I did not set the install option to cha...more >>

Hello All, I am looking into a replication based enterprise application for the company I work for and I can't find answers to a few questions. I hope that you Guru's know if it's possible to do these things. My company has several remote / disconnected "branches" and "franchises" and each ...more >>

Hi, My app allows a user to add a list item, which gets assigned an ID, which is referenced in tables instead of its name. How do I merge same items added by Publisher and Subscribers into a single one and propagate the ID change to all affected tables at the applicable sites? Thanks in adv...more >>

I have a point of sale merge replication project running in production. And it works fine with bidirection data transfer. Recently though, the power was pulled to the POS device. I was only down about 10 minutes. The agent showed a stop due to the maximum number of retries at 10. However, I ...more >>

Hello, I am looking for a 3rd party tool that would synchronize a SQL database one to one and one to many. Any suggestions ? Thanks ...more >>

sql2k sp3 I know the title sounds bizarre. But its true. I was doing some disaster recovery testing to find out what would happen if our Publisher box needed to be restored from backups. I had all my backups so then I uninstalled/ reinstalled SQL, sp3, and a hotfix. I did all the restores...more >>

I am setting up SQLServer replication between servers on different domains which have a two way trust. The publishing servers are a mixture of NT and Windows 2000 The subscribibg server is Windows 2000. I have no problem subscribing to the publications on the NT servers. The trust allows me...more >>

Dear friends I have got the following unresolved conflict for the replication. We are using the merge replication. Datetime,UserAction,Database,Publication,Table,Origin_Data Source,RowGuidValue,conflict_type,reason_text,SQL 20/02/2004 15:45:58,"Conflict Loser","MainSQL","BPOMainSQL","[d...more >>

Dear Friends I have front end application of VB which use the SQL database as the backend. To have the full disaster recovery i want to put the SQL server in the replication but as the rowguide is having not null property will it create any problem to my program while inserting the rec...more >>

Hi, I use FTP Merge Replication over internet.Two weeks ago,I created the publication on the development server .Everything was working fine. But when I ran the snapshot jobs for the second time, the jobs failed.I ran them again in order to understand the exact error with OutputVerbosal 2,...more >>

Hi, I use FTP Merge Replication over internet.Two weeks ago,I created the publication on the development server .Everything was working fine. But when I ran the snapshot jobs for the second time, the jobs failed.I ran them again in order to understand the exact error with OutputVerbosal 2,...more >>

Hi Guy, Is there a way to move a database file (say c:\mydb.mdf to d:\mydb.mdf) to a different drive without making it offline with replication set on the database? Thanks, Poch ...more >>

I need to increase the size of a column from varchar(100) to varchar(140) in a table that is part of merge replication. I tried using the following, it just adds the dummy column and doesn't alter my invoice_description column with the new size. sp_repladdcolumn @source_object = 'invoice', @...more >>

Greetings... I'm having some problems with replication that I cannot explain and I thought I'd ping the newsgroups community. I have one publisher and one subscriber, and the publisher is acting as distributor as well. My problems arise when I run my application against the subscriber. My ap...more >>

Hi all 1. When i try to set up Transactional Replication, our Machinename+Dbinstance name is more than 30 Characters. Then we are getting error Error 14234 : the specified '@server' is invalid. (Valid values are retrieved by sp_helpserver) 2.Then We registered with IP+DBinstance name, when we tr...more >>

In the Push Subscription Wizard, the only options are to initialize the schema and data together, or, to start replication , the subscriber already having the schema and data. Is it possible to replicate the data only, the data on the subscriber side having been truncated or deleted ? John ...more >>

We have successfully setup merge (table) replication between servers. We are trying to set up replication for stored procedures. This way when a stored procedure to modified, it will automatically be replicated to the subscribers. A publication was created where all the articles are stored...more >>

I am getting this error while trying to setup a replication between SQL 2000 & Access database using Linked Server. The publisher already having another Access subscriber working fine with no issues. Before adding the new subscription to the same publication I have added a field exported_to...more >>

Hi there, I want to connect two computers over phone subscriber by point-to-point dial-up connection between modems for replication. If I use IP addresses to add one of the computers to the another as a new server in SQL EM surely an error (about distributor_admin...) occurs. To prevent the...more >>

Dear Friends My management people want to know about the replication of the servers and i have to make the document for the same please suggest any article which i can refere to explain the same in best manner. your earlier reply will be helpful. best regards sharad...more >>

I have a transactional replication set up. There are 2 tables and I want to replicate only rows where there is a corresponding ID field in the other table (its job adverts and job descriptions - so I only want to have the job descriptions for the adverts that are current) Ideally I would use a...more >>

i am attpemting to set up replication on a Database that at least 1/2 of the tables do not have primary keys. i only need 6 tables, really, is there a way to replicate these to another server without adding primary keys to the Tables? Thanks. Randy ...more >>

I'm trying to do replication between two SQL 2000 machines . I want to drop the foreign keys in the destination server so that the replication would work. Is there an easy way to drop all the relationships of a database other than going to each table and deleting it? Thanks.. ...more >>

Can the log shipping plan generated by the database maintenance wizard be customized ot include compression?...more >>

Hi, How to identify my sql server is setup(enable) to replication or not in SQL or any sys proc Regards Dishan ...more >>

I have used Enterprise Manager to configure replication on SERVER1. SERVER1 is the Distributor and the Publisher. SERVER1 is a SQL Server 2000 that runs in mixed mode (SQL and Windows Authentication). The SQL Server and SQL Server Agent startup accounts are the same which is also a local user...more >>

I am running SQL 2000 on Win 2000. When I expand my main server there is an error (red circle with white X) on my replication monitor. When I expand it further, there is an error on the publishers folder and the agents folder. When the publishers folder is expanded, there is an error on...more >>

After I install SP3 I'm getting this error on replication could not load DL any ideas?? thank Nelson --- Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/...more >>

Hi all We have a set up Transactional Replication with queued updating option for subscriber. Our Transaction Log job is scheduled every hour. then time we have seen our TLOg is increasing, and it is more than data and index file. Then we search in MS and find increasing the frequency of log backu...more >>

Hi, Can someone tell me if the database table's owner not belongs to dbo; is it possible to create snapshot replication? Actually this database worked with JDEdwards software. Thanks a lot, Jenny ...more >>

Hi, I created a script that alters a stored procedure. I use in FTP MERGE Replication.I executed the script; sp_addscriptexec @publication = 'Publication_Deneme1' , @scriptfile = '\\pfbusiness\FTPSHARE\UPDATE_GETPLAN.sql' , @skiperror = 1 When the subscribers synchronize, I...more >>

I have a sql 7 server with a 20gb database that i want to replicate to a new sql 2000 server. How can i go about doing this? ...more >>

Hello, I'm new guy in SQL2000 Replication. When I try to set up replication by click menu->tools- >replication->Configure Publishing, Subscribers and Distribution After click the Finish Button, it show an error message "Error 21007:Cannot add the remote Distributor. Make sure that the lo...more >>

I have set up a simple merge replication between two SQL 2000 Servers. It works OK except for a table which has an INSTEAD OF trigger on it. When I add a record to this table at either the subscriber or publisher, the record does not get replicated. No conflict is generated. Should triggers be w...more >>

Hi all. When I try to initialize a database i get the Error number: 208 on a specific view. Any idéas how to fix this. Running SQL Server 2000 SP3 on Windows 2000 Server. Regards, Johan Dahlgren ...more >>

from "SQL Server 2000 Higher Avaliablity" Planning document <excerpt> Finally Transactional Replication requires prepration of schema for replication, Identity Columns and triggers must set to NOT FOR REPLICATION ; literals must be defined with apostrophes rather than Quotation marks; prim...more >>

My situation is this: I have a server (server A) with 200 separate databases named 1 through 200. Each database has a publication and a remote subscriber that connects over a 56k phone line every hour to syncronize. I want to set up a push subscription on each database on server A to a single publi...more >>

sql 2000 replication i try replicate with merge metod, but a total of 610 objets, one, only one view no is replicated thanks pd: exist this type of help in spanish version ? ...more >>

Hi We are using transactional replication with queued updating between SQL2000 Servers SP3 The queue reader fails sometimes(often) the error message "Queue Reader aborting. The step failed. The error details shows errors like 1)Server: ... , Database ... : ODBC Error:Invalid SQL data type 2)S...more >>

I'm planning to use Trans Replication (Queued updates + updatable subs) and have a few questions... Q1) Are all conflicts resolved at time of detection or can they be deferred until later? Q2) How & when does the Replication Conflict Viewer get conflicts to resolve? Is there a table of ...more >>

Hi, While trying to configure my distributor I received the following error. Error 18483: Could not connect to server because "distributor_admin" is not defined as a remote login at the server. If I do a select @@servername from my instance the @@servername matches the name of the s...more >>

I have a publication with two particular tables in that I want to filter but am unsure about what sort of filters to apply to get the desired result. The two tables are joined: tblAssetAnalysisLink joins to tblAnalysisClass on intAnalysisClassID. There are several Analysis Classes. i.e. t...more >>

Hi all, I am trying to configure an MSDE remote database to register a pull subscription with a central SQL2000 server programatically via SQL-DMO. I keep getting the following error 'Cannot have an anonymous subscription on a publication that does not have an independant agent'. I have succes...more >>

I tried setting up a Merge Replication between a MSDE 2000 and a SQL Server 2000. When I set up the Replication, with a Pull subscription from the MSDE, I get the error "The schema script 'C:\Program Files\Microsoft SQL Server\... .sch' could not be propogated to the subscriber". I think i'm ...more >>